Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20903 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kumarapillaietl@gmail.com
first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How is union transformation utilized?
What is the difference between informatics 7x and 8x and what is latest version?
How to load a Dimension ? and how to load a fact table?
Mention few power centre client applications with their basic purpose?
Name the different lookup cache(s)?
What the difference is between a database, a data warehouse and a data mart?
wat are deployement groups in informatica, how it will be used for developers
How big was your fact table
How to Create a folder using pmrep command?
What is a dimensional model?
According to his methodology what all you need before you build a datawarehouse
How to create the source and target database connections in server manager?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain incremental aggregation in informatica
