how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 15922 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 |
What is an expression transformation in informatica?
what are the unix commands to start the wrk flow ?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
where to select code page option?
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.
what are factless facts? And in which scenario will you use such kinds of fact tables.
what is parallel querying and what r hints.
What is IQD file?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Teradata 
