how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 29068 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
How can repository reports be accessed without sql or other transformations?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What do you understand by term role-playing dimension?
explain about unit testing? in real time?
define galaxy repository in informatica
pmscmd startworkflow -sv
What is the sequence generator transformation in informatica?
How to extract sap data using informatica?
What is dimensional table?
How you can differentiate between connected lookup and unconnected lookup?
Explain lookup transformation is active in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
design of staging area?
