How the informatica server sorts the string values in Rank
transformation?
- 1 Answers
- 18191 Views
- Informatica, I also Faced
- E-Mail Answers
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 |
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
Separate from a database, an information bazaar, and an information stockroom?
What is confirmed dimension with scenario
How might you approve all mappings in the archive all the while?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
how to join the 2 different table with different columns in informatica?
In a sequential batch can u run the session if previous session fails?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
can we override a native sql query within informatica? How do we do it?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What is the Difference between DSS & OLTP?
Teradata 
