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

Post New Answer

More Informatica Interview Questions

What is workflow manager?

0 Answers  


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,


In joiner, how to load Master table in Target?

2 Answers  


my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


What are the different types of transformation available in informatica.

0 Answers  






hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


What is exclusive and normal mode for repository services?

0 Answers  


Explain sessions. Explain how batches are used to combine executions?

0 Answers  


how to calculate the optimum cache size in aggregator transformation?

1 Answers  


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


How to delete the data in the target table after loaded.

3 Answers   TCS,


following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  


Categories