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
- 8855 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 workflow monitor?
How to open an older version of an object in the workspace?
Explain what is informatica metadata and where is it stored?
How do you load alternate records into different tables through mapping flow?
What is a mapplet/worklet in informatica?
What is the session task and command task?
Why filter transformation is an active one?
What is the difference between informatics 7x and 8x and what is latest version?
waht type of interface is used for testing the data in informatica
Briefly define reusable transformation?
What is powercenter on grid?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to delete duplicate row using informatica?
What is a code page?
How union transformation is used?
