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 mapplet/worklet in informatica?
Please let me know how to make encryption and decryption with example?
What is incremental aggregation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the types of caches in lookup?
Plz can any one say me how to get the informatica certification materials and dumps
What are the various types of transformation?
What is transformation?
what is Active lock explain
Briefly explain the aggregator transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the databases that informatica can connect to windows?
What is the need of an ETL tool?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?