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
- 1954 Views
- I also Faced
- E-Mail Answers
Answer / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
Global and Local shortcuts. Advantages.
what is the significance of newlookup port in dynamic look up
h0w many versions have been developed of onformatica so far?
how do the project develops? pls specify right from the start to end in step by steps.
How the informatica server increases the session performance through partitioning the source?
Describe an informatica powercenter?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How can we improve session performance in aggregator transformation?
what is the dashbords?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
Teradata 
