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
- 29462 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 the command used to run a batch?
What are the differences between oltp and olap?
How an expression transformation differs from aggregator transformation?
What are pre and post-session shell commands?
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
Explain the different dimensions.
How many dimensions are there in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is size of u r database?
Differentiate between Load Manager and DTM?
Explain what are the different types of transformation available in informatica.
What is the scenario which compels informatica server to reject files?
what are 3 tech challenges/ common issues you face?
Why do we need informatica?
What is data caches/ index caches?
