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
- 7339 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
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Explain do we need an etl tool? When do we go for the tools in the market?
Explain etl?
Explain what is etl process? How many steps etl contains explain with example?
what are the reporting tools and difference between them?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is the difference between project backlog and product backlog?
What is the difference between Data Warehousing and Data Mining?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Do we need an ETL tool? When do we go for the tools in the market?
Explain about enterprise scalability and roi of data integration suite?
how to connect to a flatfile through ftp in informatica
what is pmrep command?
What is abap? What are idocs?
