Interested to Buy Any Domain ? << Click Here >> for more details...
How the informatica server sorts the string values in Rank
transformation?
- 1 Answers
- 18744 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 |
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?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to eliminate 1st and last rows from the source and load the inbetween rows.
what is lookupoverriding?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
HOW DO YOU CONNECT TO REMOTE SERVER ?
What is meant by lookup transformation? Explain the types of lookup transformation?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What is an aggregator transformation? it is active why cant it be passive explain?
In which scenario did you used pushdown optimization?
Explain in detail scd type 2 through mapping.
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Teradata 
