how to get the first row without using rank t/r?

Answer Posted / basi

your question is worng . because you are asking fist row
why are you using rank t/r

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On which transformations you created partitions in your project?

756


What is aggregator transformation in informatica?

534


Is it possible to revert a global repository to local one and why?

604


Explain lookup transformation is active in informatica

651


How many numbers of sessions can one group in batches?

611






What is session task and command task?

638


What is informatica?

669


What is the use of target designer?

597


Mention a few design and development best practices for informatica?

549


r u done any partitions in ur project?

1394


How we can create indexes after completing the loan process?

720


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8515


Where is metadata stored?

612


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6452


To import the flat file definition into the designer where should the flat file be placed?

666