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
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 u use pdf file in informatica source?
what are the real time problems generally come up while doing or running mapping or any transformation?
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?
How do you migrate data from one environment to another?
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
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to convert flat file into xml file? How to tune joiner?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a surrogate key?
I have source like this 1:2;3. so i want to load the target as 123
What is update strategy transform?
How do you load first and last records into target table?