Explain Process flow in data warehouse??
Answer / parvar
1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house
| Is This Answer Correct ? | 2 Yes | 0 No |
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are the various file formats involved in reportnet?
Why fact table is in a normal form?
What are session timeout and application timeout? Where we have to do this process?
What are parallel querys and query hints?
How to create prompts in report net?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
After the complete generation of a report who will test the report and who will analyze it?
Explain bus schema?
How to answer the question how many fakt table in your datawarehouse and what size it have?
What is scd1 , scd2 , scd3?
Explain datawarehousing?