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
have u done any performance tuning? how u ll do?
Which files are created during the session rums by informatics server?
what is mean by complex business rule ?
Clarify the aggregator change?
what is index?how it can work in informatica
How would you copy the content of one repository to another repository?
scenario where i can use only concurrent execution of workflow.
What are the different options available for update strategy?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the advantages of using informatica as an etl tool over teradata?
Informatica Checkpoints
What does “tail –f” command do and what is its use as an Informatica admin.
Explain lookup transformation is active in informatica
What is a node in Informatica?
How to extract sap data using informatica?