Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16719 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 the size of u r source(like file or table)?
What is Data Caches size?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between stop and abort in informatica
Explain sessions. Explain how batches are used to combine executions?
design of staging area?
can anyone suggest best free Talend data integration training online
Explain the difference between a data warehouse and a data mart?
What are the types of schemas we have in data warehouse.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the difference between informatica 7.0 and 8.0?
What is an expression transformation?
Does an informatica transformation support only aggregate expressions?
Enterprise data warehouse your projects phase by phase explain?
