How the informatica server sorts the string values in Rank
transformation?
- 1 Answers
- 18200 Views
- Informatica, I also Faced
- E-Mail Answers
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 are the types of caches in lookup?
What is target designer and target load order?
What is the need of an ETL tool?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How can you increase the performance in joiner transformation?
What do you understand by SOA of Informatica?
How do you promote a non-reusable transformation to reusable transformation?
What is domain in terms of informatica?
How to load a Dimension ? and how to load a fact table?
What are different types of transformations available in informatica?
How to use procedural logic inside infromatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is blocking transformation?
What is a rank transform?
