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

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers

What are reusable transformations in how many ways we can create them?

2 Answers

Explain lookup transformation source types in informatica

0 Answers Informatica,

what is informatica metadata?

0 Answers

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers TCS, Wipro,

What is an expression transformation?

0 Answers

What is a predefined event?

0 Answers

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers iGate,

What is difference between Mapplet and reusable transformation?

9 Answers Wipro,

Where is metadata stored?

0 Answers

What are the designer tools for creating tranformations?

1 Answers Informatica,

How many types of sessions are there in informatica.please explain them?

0 Answers Informatica,

For more Informatica Interview Questions Click Here