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
- 8682 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 standalone command task?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what is the -ve test case in your project.
What do you mean by filter transformation?
Differentiate between router and filter transformation?
How to create the source and target database connections in server manager?
How to do the error handling of if ur source is flatfiles?
How many dimensions are there in informatica?
How do you use reject loader.
my source is junk data how will u remove that junk data by using unix please any one replay me
can we override a native sql query within informatica? How do we do it?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is Cognos script editor?
Differentiate between a repository server and a powerhouse?
