sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answer Posted / 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 |
Post New Answer View All Answers
Quickly characterize reusable change?
Write the unconnected lookup syntax?
What are the informatica performance improvement tips
What are the different lookup cache(s)?
where to store informatica rejected data?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is workflow? What are the components of workflow manager?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is workflow manager?
Target increases every day even though no new record was inserted
What is a difference between complete, stop and abort?
Why do we need informatica?
What is workflow monitor?
Do you find any difficulty while working with flat files as source and target?
Why is sorter an active transformation?