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
- 7345 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
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 many steps etl contains?
List few etl bugs?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are cubes and olap cubes?
how do u identify the changed records in operational data?
Can u access a repository created in previous version of Informatica?
what is session partitioning?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do use session mapping parameters ?(in which transformation)
What is initial load and what is full load?
what are the facilities provided by data warehouse to analytical users?
Teradata 
