Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??

Answers were Sorted based on User's Feedback



Input is like 1 1 1 2 ..

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

Input is like 1 1 1 2 ..

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

Input is like 1 1 1 2 ..

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

Post New Answer

More Informatica Interview Questions

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,


what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  


can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


How do you migrate data from one environment to another?

0 Answers  


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,






In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


What is a surrogate key?

0 Answers  


I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,


What is update strategy transform?

0 Answers  


How do you load first and last records into target table?

0 Answers  


Categories