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
- 6542 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
What is a staging area? What is the purpose of a staging area?
What are your responsibilities as an etl tester?
Explain do we need an etl tool?
how to connect to a flatfile through ftp in informatica
How etl testing is different from database testing?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is tracing level?
Do we need an ETL tool? When do we go for the tools in the market?
what is session partitioning?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What are snapshots?
what are the reports developed in sap bw project and what is the requirement for developing it?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What are materialized views & where do we use them?
