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 |
What is expression transformation?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
I want skip first 5 rows to load in to target? what will be the logic at session level ??
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What is the sql query overwrite in source qualifier in informatica
How i can upload the MainFrame source For Informatica ?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to differentiate between the active and passive transformations?
how to insert header after each group.
What are the phases in SDLC?
What are the differences between joiner transformation and source qualifier transformation?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?