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
- 7207 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 |
how many maximum session supports to multiload in teradata ??
how do u decide whether u need to do aggregations at database level or at Informatica level?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
what is pmrep command?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What are dimensions?
What is a mapping?
How etl testing is different from database testing?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Explain the key challenges that you face while performing etl testing.
Teradata 
