100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
Answer Posted / mayur
SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the different dimensions.
What is dimensional table? Explain the different dimensions.
How can we delete duplicate rows from flat files?
draw informatica architecture 8.6 ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to extract the informatica rejected data?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Differentiate between joiner and lookup transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
What are ETL Tools?
How would you copy the content of one repository to another repository?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Which transformation should we use to normalise the COBOL and relational sources?