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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
In how many ways we can create ports?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to update a particular record in target with out running whole workflow?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to convert multiple rows to single row (multiple columns) in informatica
Whats there in global repository
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What's the layout of parameter file (what does a parameter file contain?)?
What are the different types of transformation available in informatica.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How does a sorter cache works?
How do you promote a non-reusable transformation to reusable transformation?
What are the differences between a connected lookup and unconnected lookup?