what is the architecture of any Data warehousing project?
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 aggregator transformation in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
On which transformations you created partitions in your project?
How to elaborate powercenter integration service?
Explain about Informatica server process that how it works relates to mapping variables?
How can you define user defied event?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can we create multiple integration service on single repository?
How to improve the performance of a session using sorter transformation?
What will be the approach?
What is the different lookup cache(s)?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How do you load only null records into target?
Design a mapping to load the cumulative sum of salaries of employees into target table?