Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 21111 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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What does “tail –f” command do and what is its use as an Informatica admin.
What is transformation?
Design time, run time. If you don't create parameter what will happen
What are the reusable transformations?
How can we delete duplicate rows from flat files?
What are roles and groups and benefits of using them?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the meaning of decode in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How identifying bottlenecks in various components of informatica and resolving them?
Mention few power centre client applications with their basic purpose?
can we override a native sql query within informatica? How do we do it?
What do you mean by filter transformation?
Explain the scenario which compels informatica server to reject files?
