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
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?
Describe an informatica powercenter?
Which development components of informatica have the highest usage?
How identifying bottlenecks in various components of informatica and resolving them?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is informatica worklet?
What is the use of target designer?
What is a joiner transformation and why it is an active one?
What is option by which we can run all the sessions in a batch simultaneously?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What does command task mean?
What are the designer tools for creating transformations?
What are the main issues while working with flat files as source and as targets ?
draw informatica architecture 8.6 ?
