how can we load first and last record from a flat file
source to target?
- 7 Answers
- 27083 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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are Dimensional table?
What are mapplets? How is it different from a Reusable Transformation?
What is a transaction control transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
can we override a native sql query within informatica? Where do we do it?
Which transformation is needed while using the Cobol sources as source definitions?
How do you migrate data from one environment to another?
What is an unconnected transformation?
What is the benefit of session partitioning?
How can we use batches?
What is union transformation in informatica?
How many types of sessions are there in informatica.please explain them?
explan ur project architecture?
What are some examples of informatica etl programs?
