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


Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active?

594


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5826


What are the mapping parameters and mapping variables?

624


What is meant by query override?

640


What is InformaticaPowerCenter?

692






Explain the code page compatibility?

643


Which is the t/r that builts only single cache memory?

713


What are the new features of informatica 9.x in developer level?

567


what are the Methods For Creating Reusable Transformations?

649


Which development components of informatica have the highest usage?

596


How do you convert single row from source into three rows into target?

606


what is the Default Source Option For Update Strategy Transformation?

758


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


What is meant by a domain?

630


Write the unconnected lookup syntax and how to return more than one column.

599