Interested to Buy Any Domain ? << Click Here >> for more details...
how the informatica server sorts the strings values in rank
transformations?
- 3 Answers
- 16694 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 improve the performance of Aggregate transformation?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
How to generate or load values in to the target table based on a column value using informatica etl tool.
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
which one is better either active or passive transformation in informatica
Can you use one mapping to populate two tables in different schemas
What exactly mentioned in High level design document.can somebody explain me sequentialy.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
How to identify this row for insert and this row for update in dynamic lookup cache
How can we get multiple output values using an unconnected lookup transformation?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Can i create a lookup table without cache.
Teradata 
