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 |
What is IQD file?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
explan ur project architecture?
What is informatica worklet?
Can we use parameters of parameter file in presession command
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
What is junk dimention?
write a query to get maximum salary from the employers table without duplicates....kindly help me
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
how can i invoke pmcmd in command line prompt
In a concurrent batch if a session fails, can you start again from that session