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
- 8799 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
Define Pmrep command?
What are the components of the workflow manager?
What is the use of an aggregator cache file?
What is status code in informatica?
How you prepared reports for OLAP?
What is aggregate cache in aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the surrogate key?
What could be the possible resons of locks by user?
What are the components of Informatica? And what is the purpose of each?
What is a filter transformation?
What are the advantages of using informatica as an etl tool over teradata?
In development project what is the process to follow for an etl developer from day1
can you please explain me pre session and post session options?
What is mapplet in informatica?
