case and like function in informtica (my source is XML).
case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200'
case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit'
etc.,,



case and like function in informtica (my source is XML). case when OS Like'%Windows%' and..

Answer / shake

Its is possible using regular expression in informatica

https://etltechsolutions.wordpress.com/

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can you access a repository created in previous version of Informatica?

1 Answers  


write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,


Differentiate between mapping parameter and mapping variable?

1 Answers  


How do you load first and last records into target table?

0 Answers  


Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,






what is degenerated dimension?

1 Answers   IBM,


What are the features of complex mapping?

0 Answers  


1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,


I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  


what is constraint based loading

2 Answers   IBM,


After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  


Explain incremental aggregation in informatica

0 Answers   Informatica,


Categories