how the informatica server sorts the strings values in rank
transformations?
Answer Posted / amit kumar
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 |
Post New Answer View All Answers
How we can use union transformation?
Explain lookup transformation is active in informatica
Explain informatica architecture - version 8 / 9
Explain scd type 3 through mapping.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What do you understand by SOA of Informatica?
What is update strategy transform?
What is joiner change?
What is different between the data warehouse and data mart?
What is data transformation manager process?
Where can we find the throughput option in informatica?
What are the different versions of informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what is the hint? how to use it to reduce the query processing in program?
Differentiate between reusable transformation and mapplet.