Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16582 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / amit kumar
When the Integration Service runs in the ASCII data
movement mode, it sorts session data using a binary sort
order.
When the Integration Service runs in Unicode data movement
mode, the Integration Service uses the sort order
configured for the session. You select the session sort
order in the session properties. The session properties
lists all available sort orders based on the code page used
by the Integration Service.
For example, you have a Rank transformation configured to
return the top three values of a string port. When you
configure the workflow, you select the Integration Service
on which you want the workflow to run. The session
properties display all sort orders associated with the code
page of the selected Integration Service, such as French,
German, and Binary. If you configure the session to use a
binary sort order, the Integration Service calculates the
binary value of each string, and returns the three rows
with the highest binary values for the string.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain pushdown optimization $pushdownconfig parameter - informatica
Enlist the various types of transformations.
What are the databases that informatica can connect to windows?
What you know about transaction control transformation?
What are multi-group transformations?
Why do you use Mapping Parameter and mapping variable?
What is data movement mode in Informatica and difference between them?
server hot-ws270 is connect to Repository B. What does it mean?
Explain what is informatica metadata and where is it stored?
How can we use mapping variables in informatica? Where do we use them?
what is INFORMATICA TESTING process
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you load only null records into target?
How many types of sessions are there in informatica.please explain them?
