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.,,
Answer / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
Using Expression transformation how to remove duplicate records from a relational source?
What are reusable transformations in how many ways we can create them?
Explain lookup transformation source types in informatica
what is informatica metadata?
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
What is an expression transformation?
What is a predefined event?
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.
What is difference between Mapplet and reusable transformation?
Where is metadata stored?
What are the designer tools for creating tranformations?
How many types of sessions are there in informatica.please explain them?