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
What is a router transformation?
What are the modules in Power Center
What is resilience time?
have u done any performance tuning? how u ll do?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Why sorter is an active transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
expain about the tune parameters?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the procedure for creating independent data marts from informatica 7.1?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Differentiate between a repository server and a powerhouse?
what is diff b/t sorter t/r and agg have the option sorter property...
What is decode in static cache?
Clarify the utilization of aggregator cache record?
