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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What does role playing dimension mean?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Whats there in global repository
permutations of mapplet
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 are the types of caches in lookup?
How can we delete duplicate rows from flat files?
how many types of dimensions are available in informatica?
What is an expression transformation in informatica?
How to go to the older version for a mapping?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a joiner transformation?
How can you differentiate between powercenter and power map?