1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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


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 is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

how to create a sample mapping for dynamic lookup transformation

2 Answers  

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  




i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

what is difference between mapping and mapplet ?

2 Answers   TCS,

What is dynamic cache?

0 Answers  

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

How can informatica be used for an organization?

0 Answers  

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

What is informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories