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
Explain the aggregator transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to update source definition?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to use pmcmd utility command?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Different circumstance which drives informatica server to expel records?
What if the source is a flat-file?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to implement security measures using repository manager?
Explain pushdown optimization and types in informatica
Make a note of the quantity vaults made in informatica?
Which transformation is needed while using the Cobol sources as source definitions?