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
2595 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 the difference is between a database, a data warehouse and a data mart?

0 Answers

What is a joiner transformation?

0 Answers

What is rank transform?

0 Answers

In informatics server which files are created during the session rums?

0 Answers

how can you load data into target table without leading zeor's

4 Answers Deloitte,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers Axtria,

What are set operators in Oracle

3 Answers Deloitte, Wipro,

How to generate sequence numbers?

0 Answers

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers TetraSoft,

Differentiate between Load Manager and DTM?

0 Answers

how can we perform incremental aggregation?explain with example?

9 Answers IBM, TCS,

What are roles and groups and benefits of using them?

0 Answers

For more Informatica Interview Questions Click Here