List the transformation used for the following:
(1) Heterogeneous Sources
(2) Homogeneous Sources
(3) Find the 5 highest paid employees within a dept.
(4) Create a Summary table
(5) Generate surrogate keys
Answer / nagapuri
1)Joiner Transformation
2)Source Qualifier and Joiner transformation
3)Rank Transformation.
4)Aggregator Transformation
5)Sequence Generator Transformation
Is This Answer Correct ? | 6 Yes | 0 No |
Where is metadata stored?
Design a mapping to get year of join for each employee.
How to load relational source into file target?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
According to his methodology what all you need before you build a datawarehouse
how to import multiple flat files in to single target where there is no common column in the flat files
What do you mean by filter transformation?
List the transformation in informatica.
How many cubes create from a single model?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
What are junk dimensions?