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
Scheduling properties,whats the default (sequential)
What are the informatica performance improvement tips
Why update strategy and union transformations are active?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are multi-group transformations?
What is a joiner transformation and why it is an active one?
How do you load first and last records into target table?
Explain about cumulative Sum or moving sum?
What is enterprise data warehousing?
How we can create indexes after completing the load process?
What is sorter transformation?
What do mean by local and global repository?
tell me 5 session failure in real time how can you solve that in your project?
Define filter transformation?
Can we override a native sql query within informatica?