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 can you generate reports in informatica?
Reusable transformation and shortcut differences
Define sessions in informatica etl?
Is it possible to use a client with different version than that of its Informatica server?
What is decode in static cache?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
expain about the tune parameters?
What is joiner transformation?
Different circumstance which drives informatica server to expel records?
Differentiate between a repository server and a powerhouse?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is domain and gateway node?
What do you understand by SOA of Informatica?
What is an aggregator transformation?