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

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.,,

Question Posted / john

1 Answers
2600 Views
I also Faced
E-Mail Answers

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

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers HP,

lookup transformation with screenshots

0 Answers TCS,

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers Amazon, IBM, Wipro,

how can u tune u r informatica mapppings

2 Answers CTS,

What is log file,and where is it located,why u r using the log file

1 Answers TCS,

What is active and passive transformation?

10 Answers

how will you remove the duplicate records from flat file without using sorter?

7 Answers

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers

How do you create single lookup transformation using multiple tables?

6 Answers TCS,

I have source like this 1:2;3. so i want to load the target as 123

4 Answers HP,

How Union Transformation is an Active Trans?

6 Answers

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers CTC,

For more Informatica Interview Questions Click Here