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 are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


How can we use mapping variables in informatica?

0 Answers  






without update strategy how to insert &update?

1 Answers   DELL,


how to duplicates from expression transformation without using sorter before that

1 Answers  


Do you find any difficulty while working with flat files as source and target?

0 Answers  


Scheduling properties,whats the default (sequential)

0 Answers  


What is the need of building a data warehouse?

2 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,


Categories