without using rank transformation how can we rank items by
using some other transformations
Answer Posted / bhupal
Use sorter t/r first and sort the data by using which port
u want
next use that expression t/r to generate the sequence by
using variable port
next u can use the filter t/r to restrict the data or
required ranks as a output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
can u give example for factless fact table
What is the difference between STOP and ABORT options in Workflow Monitor?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the different types of repositories created using informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a joiner transformation and why it is an active one?
What is source qualifier transformation in informatica?
Tell me about MD5 functions in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain how to import oracle sequence into informatica?
What is data transformation manager process?
Write the unconnected lookup syntax and how to return more than one column.
How to generate sequence numbers using expression transformation?
Explian the Process of deployment groups in informatica