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
- 8692 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / redflower
src->sq->aggregator->filter->target
from aggt/r we would calculate count(empid)
for eliminating duplicates we will write the filter condition
count(empid)=1
| Is This Answer Correct ? | 0 Yes | 6 No |
How to use procedural logic inside infromatica?
What is the Router transformation?
how can we run workflow with pmcmd?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What are the static cache and dynamic cache in informatica?
What is powercenter on grid?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is a unit Testing?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
why union is active transformation?
what is meant by data driven.. in which scenario we use that..?
Teradata 
