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 Posted / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
If informatica has its scheduler why using third party scheduler?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what are 3 tech challenges/ common issues you face?
Tell me about MD5 functions in informatica
How do you use reject loader.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is event and what are the tasks related to it?
What is a dimensional model?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is mapplet in informatica?
What is rank transformation in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Different qualification between a related rotate toward the sky and isolates look upward?
Is there any target staging area in informatica not staging area