Interested to Buy Any Domain ? << Click Here >> for more details...
Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
- 3 Answers
- 8955 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gyana
after source qualifier take a rank t/r
set the group by as column_id and in rank property set
# the number of rank=1
after that connect to target .you can get the desired result
SOURCE---->SQ--->RANK T/R----->TARGET
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is lookup transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Can we get 1st record through Informatica(without sequence number).
What is lookup change?
Slowly changing dimensions, types and where will you use them
What is fact table? Explain the different kinds of facts.
How can a transformation be made reusable?
Define sessions in informatica etl?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the different components of powercenter?
can anyone explain me about retail domain project in informatica?
What are the data movement modes in informatica?
Is there any target staging area in informatica not staging area
What are roles and groups and benefits of using them?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
