Interested to Buy Any Domain ? << Click Here >> for more details...
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
where to store informatica rejected data? How to extract the informatica rejected data?
waht type of interface is used for testing the data in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define sessions in informatica etl?
Write the unconnected lookup syntax?
How many input parameters can exist in an unconnected lookup?
explan ur project architecture?
How can we handle two sessions in informatica?
What does update strategy mean, and what are the different option of it?
How do you take back up of repository?
Describe expression transformation?
What do you mean by channel change?
What are the main issues while working with flat files as source and as targets ?
