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 if the source is a flat-file?
Define pmcmd command?
Explain how many types of dimensions are available in informatica?
Informatica settings are available in which file?
How identifying bottlenecks in various components of informatica and resolving them?
Can we change Dynamic to Static or Persistent cache? If so what happens?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is INFORMATICA TESTING process
What are the transformations that are not supported in mapplet?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the use of transformation?
draw informatica architecture 8.6 ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the new features of informatica 9.x at the developer level?