How the informatica server sorts the string values in Rank
transformation?
Answer / swetha
When the informatica server runs in the ASCII data movement
mode it sorts session data using Binary sortorder. If yoU
configure the seeion to use a binary sort order, the
informatica server caluculates the binary value of each
string and returns the specified number of rows with the
higest binary values for the string.
Is This Answer Correct ? | 15 Yes | 4 No |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
what is galaxy repository?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is the use of transformation?
Explain the different lookup methods used in informatica?
can we override a native sql query within informatica? How do we do it?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
What are the differences between joiner transformation and source qualifier transformation?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE