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

How union transformation is used?

671


What do you understand by term role-playing dimension?

686


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817


How can we update a record in the target table without using update strategy?

757


What are the limitations of joiner transformation?

746






Informatica settings are available in which file?

685


draw informatica architecture 8.6 ?

3545


What is a joiner transformation and why it is an active one?

653


Differences between version 7.x and 8.x.

1522


Why update strategy and union transformations are active? Explain with examples.

816


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

705


how we can load rejected record's at run time?(not through bad files)

2011


if we have a delimiters at unwanted places in a flat file how can we over come those.

1648


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1650


Why do we need informatica?

643