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 Posted / 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 |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
What are the settings that you use to configure the joiner transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is an expression transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the need of etl tools?
How many ways are there to do 'remove duplicate records in informatica'?
What is event and what are the tasks related to it?
What is the difference between informatica 7.0 and 8.0?
How to do the error handling of if ur source is flatfiles?
What is the way to execute pl/sql script using informatica mapping?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the differences between a connected lookup and unconnected lookup?
What is aggregator transformation in informatica?