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
What is the difference between source qualifier transformations source filter to filter transformation?
What are the new features of Power Center 5.0?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are different types of transformations available in informatica?
Why do you use Mapping Parameter and mapping variable?
What is repository manager?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the function of look up transformation?
What is the need of etl tools?
Where do we use mapping variables in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
How do you promote a non-reusable transformation to reusable transformation?
What are the types of lookup transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is session task and command task?