Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16718 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 handle decimal places while importing a flatfile into informatica?
Can you generate reports in Informatcia?
Explain about perform recovery?
What is lookup change?
Diffrence between static and dynamic cache
What are active and passive transformations?
To achieve the session partition what r the necessary tasks u have to do?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
What is a shortcut and copy in Informatica and how two are different with each other?
Teradata 
