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

tell me 5 session failure in real time how can you solve that in your project?

1631


What are the different options available for update strategy?

580


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1254


How do you load only null records into target?

742


What is difference between a gateway node and worker node?

625






hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1529


What is the difference between stop and abort in informatica

663


What is a filter transformation?

566


In informatica workflow manager, how many repositories can be created?

781


How does the aggregator transformation handle null values?

697


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1080


Explain constraint based loading in informatica

659


Write the program through which the records can be updated?

516


What are the main issues while working with flat files as source and as targets ?

654


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1651