Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
Answer Posted / 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 View All Answers
What are the different ways to implement parallel processing in informatica?
Explain incremental aggregation in informatica
What are the new features of Power Center 5.0?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the use of transformation?
Can we create a Integration service without a Repository service and vice versa?
What is the Rank index port in Rank transformation?
Whats there in global repository
Can we get 1st record through Informatica(without sequence number).
What is workflow manager?
Enlist the advantages of informatica.
How to extract sap data using informatica? What is abap? What are idocs?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How many ways are there to create ports?
How many input parameters can exist in an unconnected lookup?