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 we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Could any one to tell Fact table Partitioning?
have u done any performance tuning? how u ll do?
where to store informatica rejected data? How to extract the informatica rejected data?
Mention few power centre client applications with their basic purpose?
what is the use of Java Transformation in Informatica 8.x?
Which are the different editions of informatica powercenter that are available?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What is a test load?