from source qualifier map the column(id) into two fields of rank (id,id

Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??

Question Posted / palthepu_santosh

Answer Posted / palthepu_santosh

from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain pmcmd command usage in informatica

1136

Explain lookup transformation is active in informatica

1107

What is domain and gateway node?

1165

What is the function of look up transformation?

1123

If informatica has its scheduler why using third party scheduler?

1268

Explain the different dimensions.

967

In development project what is the process to follow for an etl developer from day1

1724

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

2038

What is Cognos script editor?

4235

What is rank transform?

997

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

Name the different lookup cache(s)?

1235

Is there any target staging area in informatica not staging area

2580

what is the size of u r source(like file or table)?

2272