Interested to Buy Any Domain ? << Click Here >> for more details...
List the transformation used for the following:
(1) Heterogeneous Sources
(2) Homogeneous Sources
(3) Find the 5 highest paid employees within a dept.
(4) Create a Summary table
(5) Generate surrogate keys
- 1 Answers
- 3577 Views
- I also Faced
- E-Mail Answers
Answer / nagapuri
1)Joiner Transformation
2)Source Qualifier and Joiner transformation
3)Rank Transformation.
4)Aggregator Transformation
5)Sequence Generator Transformation
| Is This Answer Correct ? | 6 Yes | 0 No |
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
how to design mapping half of source table records into one target and remaining half into another target
What is parameter file?
What are the Differences between connected and unconnected lookup?
What is depict expression change?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
explan ur project architecture?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Teradata 
