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 / 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 |
Post New Answer View All Answers
what is $$$$?
How can informatica be used for an organization?
Implementation methodology
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is mapping debugger?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is joiner transformation in informatica?
How are indexes created after completing the load process?
What do you understand by a term domain?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do we call shell scripts from informatica?
what is the Default Source Option For Update Strategy Transformation?
In development project what is the process to follow for an etl developer from day1
How we can create indexes after completing the loan process?