My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9132 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / kiran
take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to extract sap data using informatica? What is abap? What are idocs?
can we override a native sql query within informatica? Where do we do it? How do we do it?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How do you load only null records into target?
What are the differences between source qualifier and joiner transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
If informatica has its scheduler why using third party scheduler?
What is the use of transformation?
What is workflow manager?
What is sorter transformation?
Make a note of the quantity vaults made in informatica?
what is the Default Source Option For Update Strategy Transformation?
On which transformations you created partitions in your project?
4 yrs etl devloper roles and responsibilities?any body give solutions
