Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9617 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / harish konda
First connect the exp1 with source and Sequence t/f's.
And next take the sorter and sort the data in descending
order of NEXTVAL port.
And again connect sorter to exp2 and connect sequence t/f to
this exp2.
And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
What are the prerequisite tasks to achieve the session partition?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a shortcut and copy in Informatica and how two are different with each other?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the meaning of up gradation of repository?
How might one distinguish in the case of mapping is right or not without associating session?
What is blocking transformation?
What are the different transaction levels available in transaction control transformation?
What is the scenario which compels informatica server to reject files?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
explan ur project architecture?
Which transformation should we use to normalise the COBOL and relational sources?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the etl program with few examples.
