sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answers were Sorted based on User's Feedback
Answer / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
Is This Answer Correct ? | 6 Yes | 5 No |
Answer / mike
well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row
correct me if i was wrong
Is This Answer Correct ? | 1 Yes | 5 No |
Using Expression transformation how to remove duplicate records from a relational source?
How to load last 10 records of flat file in to the target?
Do you find any difficulty while working with flat files as source and target?
What are parallel querys and query hints?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
How to do unit testing in informatica?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the prerequisite tasks to achieve the session partition?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,