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.,,
Answer / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
Is This Answer Correct ? | 2 Yes | 0 No |
Can you access a repository created in previous version of Informatica?
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
Differentiate between mapping parameter and mapping variable?
How do you load first and last records into target table?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is degenerated dimension?
What are the features of complex mapping?
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..
what is constraint based loading
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?
Explain incremental aggregation in informatica