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 to join two flat files in informatica?
Explain about HLD and LLD ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
What is a passive transformation?
how many types of dimensions are available in informatica?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
why union transformation is active transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain the scenario which compels informatica server to reject files?
Why filter transformation is an active one?