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
- 29433 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
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
Explain how many types of dimensions are available in informatica?
What is the need of an ETL tool?
How to load data in informatica ?
What is mapplet in informatica?
What is dynamic cache?
How might you approve all mappings in the archive all the while?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is incremental aggregation?
What is meant by lookup transformation?
What is sorter transformation?
What is joiner transformation in informatica?
What is the difference between a repository server and a powerhouse?
What is meant by a domain?
State the differences between sql override and lookup override?
