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 / 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 a node in Informatica?
What is the function of union transformation?
Mention a few design and development best practices for informatica?
What is incremental aggregation?
What is DR strategy for Informatica project?
What are the new features of informatica 9.x in developer level?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to delete duplicate row using informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
can anyone suggest best free Talend data integration training online
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to extract sap data using informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Differentiate between Load Manager and DTM?