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
- 29436 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
What is event and what are the tasks related to it?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is InformaticaPowerCenter?
Explain the different dimensions.
What is an aggregator transformation?
Can u generate reports in Informatica?
What are the new features of informatica 9.x developer?
Explain the tuning lookup transformation - informatica
Enterprise data warehouse your projects phase by phase explain?
Explain joiner transformation in informatica
How to create or import flat file definition in to the warehouse designer?
can we override a native sql query within informatica? Where do we do it? How do we do it?
can u any challenge your project?
Explain why we use partitioning the session in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
