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
- 29656 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
Is it possible to create multiple domains on a single Informatica server?
What are the components of Informatica? And what is the purpose of each?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is joiner transformation in informatica?
what is song in infrmatica...?
What is meant by active and passive transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is rank transformation?
What do think which one is the better joiner or look up?
What is workflow? What are the components of the workflow manager?
What are the prerequisite tasks to achieve the session partition?
What is dynamic cache?
What is an unconnected transformation?
What is olap (on-line analytical processing?
What is the advantage of informatica?
