Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30212 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
Difference between Target-based loading and constraint-based loading?
What are pre and post-session shell commands?
What are the different options available for update strategy?
What is meant by pre and post session shell command?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain how many types of dimensions are available in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the main features of Oracle 8i with context to datawarehouse?
How you prepared reports for OLAP?
How to Create a folder using pmrep command?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the types of presistent cache in look up tr.
what is INFORMATICA TESTING process
waht type of interface is used for testing the data in informatica
what is the complex transformation you used in informatica
