how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 27830 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ram pothineni
Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row). Connect both to target. Dont forget to give reset
option in SEQ generator.
http://it.toolbox.com/people/raambabuchowdary/
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
What are the differences between a connected lookup and unconnected lookup?
Which is the t/r that builts only single cache memory?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is olap (on-line analytical processing?
What differs when we choose the sorted input for aggregator transformation?
What are the databases that informatica can connect to windows?
Whats there in global repository
What is the Rank index port in Rank transformation?
How do you load first and last records into target table?
How many ways are there to do 'remove duplicate records in informatica'?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are ETL Tools?
Explain the types of lookup transformation?
What are the various types of transformation?
