How the informatica server sorts the string values in Rank

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

Answer / 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

More Informatica Interview Questions

What is parallel processing in informatica?

0 Answers  

Explain the difference between a data warehouse and a data mart?

0 Answers  

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

how to declare array in plsql?

1 Answers  

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   HCL, Cognizant,


3 Answers   TCS,

can u any challenge your project?

0 Answers   HP,

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

0 Answers  

What is the difference between Normal load and Bulk load?

5 Answers  

What are the uses of a Parameter file?

3 Answers   CSC,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

Enlist the differences between database and data warehouse.

0 Answers