how to load only the first and last record of a flat file
into the target?
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
Can we create a node as a gateway node and the same node can be assigned to a grid?
State the differences between sql override and lookup override?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what are the Methods For Creating Reusable Transformations?
In warehouses how many schemas are there?
What are junk dimensions?
What are the components of the workflow manager?
update strategy transformation in informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
What is status code in informatica?
What does update strategy mean, and what are the different option of it?
What is rank transformation in informatica
What are the main features of Oracle 8i with context to datawarehouse?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the different components of powercenter?