we can also use rank transformation by setting top, no of rank =1 and ena

i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow

Question Posted / syed

Answer Posted / syed

we can also use rank transformation by setting top, no of
rank =1 and enable group by port deptno

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is enterprise data warehousing?

1107

Enlist the tasks for which source qualifier transformation is used.

1075

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1229

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

1947

What are the reusable transformations?

1220

What is target designer and target load order?

1170

Which is the t/r that builts only single cache memory?

1238

How to open an older version of an object in the workspace?

1264

How can a transformation be made reusable?

1232

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

1268

What is the session task and command task?

1115

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1842

How many input parameters can exist in an unconnected lookup?

1601

what is diff b/t sorter t/r and agg have the option sorter property...

2230

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1305