top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How the informatica server sorts the string values in Rank transformation?

+2 votes
385 views
How the informatica server sorts the string values in Rank transformation?
posted Jul 13, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sort order. If you configure the session to use a binary sort order, the informatica server calculates the binary value of each string and returns the specified number of rows with the highest binary values for the string.

answer Jul 14, 2015 by Manikandan J
Similar Questions
0 votes

I have a SQL transformation with 2 ports. I want to insert the value of these ports to a table, however I am getting an error from sqlError port.

Below is the query I am writing in the source qualifier:

INSERT INTO A values (~QC_CODE~,(~QUERY_STRING~));

The QUERY_STRING port contains a sql statement which is executed on Teradata and results have to be inserted in the table A.

If I replace the first port in the above query with a constant value, I get correct results. Below is the query that gives correct result:

INSERT INTO A values ('1',(~QUERY_STRING~));
+2 votes

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

How can i get this same data with '$' symbol in target by using expression transformation in informatica?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...