what is the architecture of any Data warehousing project?
- 5 Answers
- 19603 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 the Rank index port in Rank transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
generate date / time dimension in informatica
What is meant by a domain?
Whats there in global repository
What are the new features of informatica 9.x in developer level?
What is the function of union transformation?
What if the source is a flat-file?
Separate from an archive server and a powerhouse?
What are the guidelines to be followed while using union transformation?
What are the designer tools for creating transformations?
Explain target update override in informatica
What's the layout of parameter file (what does a parameter file contain?)?
How many ways a relational source definition can be updated and what are they?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
