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
- 29657 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 extract sap data using informatica?
How do we call shell scripts from informatica?
What are the transformations that are not supported in mapplet?
How to extract the informatica rejected data?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Which version configuration tool used in ur project?
Slowly changing dimensions, types and where will you use them
How many number of sessions can one group in batches?
Where are the source flat files kept before running the session?
What are the different types of olap? Give an example?
What are active and passive transformations?
What is rank transform?
Mention some types of transformation?
Explain the informatica workflow?
