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



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

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,


,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


Could any one to tell Fact table Partitioning?

2 Answers  






have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


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

0 Answers  


Mention few power centre client applications with their basic purpose?

0 Answers  


what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,


Which are the different editions of informatica powercenter that are available?

0 Answers  


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


What is a test load?

1 Answers  


Categories