Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20592 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 surrogate key?
What are junk dimensions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to do unit testing in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enterprise data warehouse your projects phase by phase explain?
Does an informatica transformation support only aggregate expressions?
How do you take back up of repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What do you mean by enterprise data warehousing?
Can we override a native sql query within informatica?
What do you understand by SOA of Informatica?
What is a repository manager?
What is sorter transformation?
