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
- 6133 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 is data cleaning?
what is granularity in Data ware House?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What is etl process. How many steps etl contains explain with example?
Explain and compare etl & manual development?
if i have a query as flat file how can we load data to target table
Can anyone explain me a scenario from banking and finance...more precisely a mapping
explain the methodology of Data Warehousing?(Polaries)
Define Dynamic push down optmization?
what is a worklet?
Explain about round-robi?
what is Forward,Reverse and Re_engineering?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
In Which Transformation We Can Use Having Clause In Informatica?
