Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load first and last record from a flat file
source to target?
- 7 Answers
- 29156 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / dharmendra
SRC QF -> SEQ -> EXP -> AGR -> RTR -> TGT
create a port in expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
th record.create 2 condition in 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.
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is repository manager?
How do you handle two sessions in Informatica
What are ETL Tools?
During the running session, output files are created by informatica server. Enlist few of them.
explain abt ur project architecture?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
To import the flat file definition into the designer where should the flat file be placed?
Could you explain what is enterprise data warehouse?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How would you copy the content of one repository to another repository?
How to elaborate powercenter integration service?
What is confirmed fact in dataware housing?
What is status code in informatica?
without table how to come first record only in oracle?
Which transformation is needed while using the Cobol sources as source definitions?
