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

Answer Posted / gandra krishna reddy

by using first function in aggregator transformation.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define pmcmd command?

616


How are indexes created after completing the load process?

979


What is update strategy transform?

560


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5756


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1469






How can repository reports be accessed without sql or other transformations?

715


In warehouses how many schemas are there?

574


What is a pre-defined event and user-defined event?

572


How you can differentiate between connected lookup and unconnected lookup?

600


How identifying bottlenecks in various components of informatica and resolving them?

575


what is INFORMATICA TESTING process

1832


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3495


Explain the etl program with few examples.

539


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6389


Briefly describe lookup transformation?

595