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
How is union transformation utilized?
What the difference is between a database, a data warehouse and a data mart?
Which transformation should we use to normalise the COBOL and relational sources?
Explain what transformation and how many are there in informatica?
What is difference between a gateway node and worker node?
What is fact table? Explain the different kinds of facts.
What is the need for an etl tool?
How many transformations can be used in mapplets.
What is the different lookup cache(s)?
What is rank index in rank transformation?
Sequence generator, when you move from develoment to production how will you reset
Which are the different editions of informatica powercenter that are available?
What is meant by a domain?
Which development components of informatica have the highest usage?
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)