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
- 7305 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 cubes developed in a sap bw project and what is the requirement for developing it?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a lookup table in etl?
what is the use of structures?how many nodes can u create in a structure?
what is the difference between cardinality and Nullability?
what is the meaning of upgradation of Repository?
what is data modeling?
what is an ETL or ETT? And what are the different types?
What are materialized views & where do we use them?
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 do you understand by active and passive transformations?
how to load the data to fact table?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Is hadoop a etl tool?
