Search results for query: *

In my company we are looking for the best strategy for our initial load to the datawarehouse. Will appreciate if people can share different strategies that they have used to accomplish this goal. We are moving data worth 3 years and we have something like this.. Tab1 - 21 Million Tab2 - 28...

We are in the process of desiging a datamart with nightly load etl that would be developed in Informatica. Management wants us to think on the possibility of making it a real time datawarehouse. Having experience in batch ETL and already having the ETL architecture to support it I am finding it...

I am designing ETL and really confused about the whole staging architecture. Please provide me whatever links you can, I am ready to read anything. My questions are as follows. (1) Staging area between the source and the data Mart (backroom as they call it), is it supposed to be a persistent...

Are there any good books/sites/tips/discussion forums on data warehouse staging area design. I googled it but didnt get much help. Thanks.

I work for a manufacturing company and I am creating a datamart for tracking inventory of products. As part of this datamart I also need to analyse activity based costing of these products .A semifinished product is also a product for the company and we need to keep track of the cost that has...