Answer Posted / simon
Staging area is a place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data, and perform data cleansing and merging, before loading the data into warehouse.
you can refer dwhlaureate.blogspot.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
difference between repository database and repository service?
During the running session, output files are created by informatica server. Enlist few of them.
What all are steps in up gradation of Informatica server?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the advantage of informatica?
What are junk dimensions?
What is Session and Batches?
What all join we can perform in LOOKUP transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Which are the different editions of informatica powercenter that are available?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a sequence generator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How can repository reports be accessed without sql or other transformations?
