How to load only the first and last record of a flat file into
the target?
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
What are the restrictions of union transformation?
What are the mapping parameters and mapping variables?
What is joiner transformation in informatica?
What is primary and backup node?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between router and filter?
Explain the code page compatibility?
what is informatica metadata?
How can we handle two sessions in informatica?
What are the features of complex mapping?
What are the measure objects?
What is flashback table ? Advance thanks
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load unique records into one target table and duplicate records into a different target table?