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

Answer Posted / moorthy g

SQ-Sorter-Seq-Exp-Fiter(nextval=1)-Target

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does the aggregator transformation handle null values?

698


What are batches?

621


How can we use batches?

606


What does command task mean?

613


can you please explain me pre session and post session options?

6378






How to handle decimal places while importing a flatfile into informatica?

723


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1858


How do you update the records with or without using update strategy?

664


What all join we can perform in LOOKUP transformation?

567


What is native users?

725


How to generate sequence numbers using expression transformation?

641


Please let me know how to make Data masking in informatica..

1269


What is the difference between writing a joiner query in ANSI style and THETA style?

1918


Differentiate between a database and data warehouse?

654


What are the different versions of informatica?

680