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 Posted / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the need of etl tools?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a repository manager?
What is lookup transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Why filter transformation is an active one?
How does the aggregator transformation handle null values?
wf dont have integration severances how you can run?
What is meant by query override?
What is depict expression change?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is informatica metadata?
What is mapping debugger?