what is the architecture of any Data warehousing project?
- 5 Answers
- 19124 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
What is meant by lookup transformation? Explain the types of lookup transformation?
What could be the possible resons of locks by user?
Can we override a native sql query within informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the informatica performance improvement tips
What is a mapplet/worklet in informatica?
Difference between Data and Index Caches?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain dynamic target flat file name generation in informatica
How to extract sap data using informatica?
How union transformation is used?
What is the sql query overwrite in source qualifier in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
How to update a particular record in target with out running whole workflow?
