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
tell me about your project functionality
What is the function of look up transformation?
How union transformation is used?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the reusable transformations?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Briefly explain the aggregator transformation?
Enlist the various types of transformations.
where to store informatica rejected data? How to extract the informatica rejected data?
How to create a non-reusable instance of reusable transformations?
what is Active lock explain
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can we create two repositories on same database instance in oracle?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION