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.,,
- 1 Answers
- 2283 Views
- I also Faced
- E-Mail Answers
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
Explain sessions?
list out all the transformations which use cache?
what is Active lock explain
Define mapping and session?
what is the difference between informatica6.1 and infomatica7.1
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the types of data warehouses?
What are the types of presistent cache in look up tr.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
which one is better performance wise joiner or look up
How can you differentiate between powercenter and power map?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are active transformations.
What is meant by a domain?
Design time, run time. If you don't create parameter what will happen
