Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16884 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / pavan
IN RANK T/F PROPERTIES THERE IS AN OPTION "CASE SENSITIVE STRING COMPARISION " U CHEK THIS OPTION THE INTEGRATION SERVER SORTS THE STRING VALUES
| Is This Answer Correct ? | 1 Yes | 1 No |
How to load last 10 records of flat file in to the target?
Difference between Data and Index Caches?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
what is the complex transformation you used in informatica
without table how to come first record only in oracle?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
How to improve the performance of Aggregate transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
How can we get two output ports in un-connect transformation?
What r the type of indexes u generally used in informatica?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Teradata 
