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
- 6131 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagesh
For Heterogeneous sources,use joiner transformation
Homogeneous sources go for source qualifier transformation
TOP 5 SAL
SELECT ROWNUM,ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP
ORDER BY SAL DESC)
Where rownum <6
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain what are the various etl tools in the market?
what is pmrep command?
Explain about etl data integration software?
Compare ETL & Manual development?
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.
how to connect to a flatfile through ftp in informatica
what is dynamic insert?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are three tier systems in etl?
How many steps etl contains explain with example?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is Forward,Reverse and Re_engineering?
what are the types in error loging?
How many types of transformations supported by sorted input?
how do u really know that paging to disk is happening while u are using a lookup transform?
