COL1,COL2
ABC,1
XYZ,2
HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT
FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20)
O/P IS
COL1,COL2
ABC,2
XYZ,1
No Answer is Posted For this Question
Be the First to Post Answer
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
How to implement security measures using repository manager?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is sql query override? When did u use sql query override?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What are the two modes of datamovement in informatica sever?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Explain the etl program with few examples.
How do you change a non-reusable transformation to reusable transformation?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
In a sequential batch can you run the session if previous session fails?