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 use sorter transformation in joins?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
How many cubes create from a single model?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Informatica and datawarehousing courses in Pune?
How will you check the bottle necks in informatica? From where do you start checking?
Mention few power centre client applications with their basic purpose?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
how the server recognises , if the session fails after loading the 100 records in to the target