How the informatica server sorts the string values in Rank
transformation?

Answer Posted / swetha

When the informatica server runs in the ASCII data movement
mode it sorts session data using Binary sortorder. If yoU
configure the seeion to use a binary sort order, the
informatica server caluculates the binary value of each
string and returns the specified number of rows with the
higest binary values for the string.

Is This Answer Correct ?    15 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Global and Local shortcuts. Advantages.

1472


where to store informatica rejected data? How to extract the informatica rejected data?

607


Implementation methodology

1266


What is meant by active and passive transformation?

587


What are connected or unconnected transformations?

630






How to elaborate tracing level?

688


What is the difference between a repository server and a powerhouse?

820


Write the advantages of partitioning a session?

752


What can we do to improve the performance of informatica aggregator transformation?

620


what are the Methods For Creating Reusable Transformations?

650


What are the data movement modes in informatica?

707


Define filter transformation?

628


Define sessions in informatica etl?

619


Why filter transformation is an active one?

565


What are the measure objects?

666