Interested to Buy Any Domain ? << Click Here >> for more details...
list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
- 2 Answers
- 7428 Views
- I also Faced
- E-Mail Answers
Answer Posted / dw_worker
Heterogeneous sources - Joiner
Homogeneous sources - Source Qualifier
Find the 5 highest paid employees with in a dept - Rank
Create a summary table - Aggregator
Generate surrogate keys - Sequence Generator
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the session parameters? How do u set them?
Give the benefits of data integration suite?
What is etl tool in hadoop?
Explain etl?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Difference between flat files and relational sources?
SCD2 will work on only dimension tables as well as fact Table?
can be used COM component in Informatica ?
What are the names of the layers in etl?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What is tracing level and what are the types?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
what is pmrep command?
what is the main role of FI on business
what are the types in error loging?
