how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16045 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
What is Session and Batches?
What are the new features of informatica 9.x in developer level?
How to generate sequence numbers without using the sequence generator transformation?
whats the logic to load the lower level of granularity of data to fact table.
Write the different tools in the workflow manager?
what is index?how it can work in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
design of staging area?
How many types of sessions are there in informatica.please explain them?
What is meant by LDAP users?
what are the Methods For Creating Reusable Transformations?
Enlist the tasks for which source qualifier transformation is used.
What is the session task and command task?
Can informatica load heterogeneous targets from heterogeneous sources?
