Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16753 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 |
if i have a delimited file as source so how can we seperate this file into three diff targets?
What is router transformation
what is informatica metadata?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
WAT IS TEXT LOAD?
In dimension and fact table? which one holds big data?
What are batches?
what is junk dimension
What does refresh system mean, and what are its distinctive choice?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Teradata 
