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
- 29229 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / hina
Below transformation would work: Add the Nextval port of the sequence generator to both the Rank Transformations. In rank transformation select Top and Bottom resp.
------ Rank Transformation (Top)----Tgt(Ins1)
|
SQ---Sequence Generator-----
|
-------Rank Transformation(Bottom)-Tgt(Ins2)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
What do you mean incremental aggregation?
can you please explain me pre session and post session options?
lookup transformation with screenshots
What are the transformations that are not supported in mapplet?
Explain the informatica workflow?
Explain the pipeline partition with real time example?
How an expression transformation differs from aggregator transformation?
What is meant by incremental aggregation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the performance considerations when working with aggregator transformation?
What are mapplets?
What is a sorter transformation?
What is data transformation manager process?
What does update strategy mean, and what are the different option of it?
