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

Answer Posted / abhishek kumar

step 1
if first row h as not null then we can use first()
function in aggregator T/F.

step 2
use sequence generator T/F And filter T/F write condition
nextval=1

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

have u done any performance tuning? how u ll do?

1850


Which files are created during the session rums by informatics server?

699


what is mean by complex business rule ?

1712


Clarify the aggregator change?

586


what is index?how it can work in informatica

1573






How would you copy the content of one repository to another repository?

547


scenario where i can use only concurrent execution of workflow.

2529


What are the different options available for update strategy?

566


Is it possible to define a single node as a Gateway node as well as worker node?

644


What are the advantages of using informatica as an etl tool over teradata?

559


 Informatica Checkpoints

2847


What does “tail –f” command do and what is its use as an Informatica admin.

623


Explain lookup transformation is active in informatica

651


What is a node in Informatica?

615


How to extract sap data using informatica?

596