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
2665 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

What could be the possible resons of locks by user?

0 Answers

What is target load order?

0 Answers

Why use the lookup transformation ?

2 Answers Informatica,

What is the difference between view and materialised view?

6 Answers

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers Virtusa,

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers Wipro,

How to display null values on a target & non-null values on a target?

3 Answers

How many joins in Informatica

5 Answers CSC,

What happens when a session fails and you click on recover?

0 Answers

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers

What are the challenges of Dataware housing in the future?

2 Answers HP,

Briefly define a session task?

0 Answers

For more Informatica Interview Questions Click Here