1 :: If two relational tables are connected to SQ Trans, what are the possible errors it will be thrown?The only two possibilities as of I know is
Both the table should have primary key/foreign key relation ship
Both the table should be available in the same schema or same database
this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department.
Advantages of having a EDW:
1. Golbal view of the Data
2. Same point of source of data for all the users acroos the organization.
3. able to perform consistent analysis on a single Data Warehouse.
to over come is the time it takes to develop and also the management that is required to build a centralised database.
We can not insert or update the cache.
We can insert rows into the cache as we pass to the target.