Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2586 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
What are the different types of repositories created using informatica?
Can you use flat files in Mapplets.
What are the popular informatica products?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What does “tail –f” command do and what is its use as an Informatica admin.
What are batches?
What is data caches/ index caches?
Describe expression transformation?
what is $$$$?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to differentiate between the active and passive transformations?
Make a note of the quantity vaults made in informatica?
What is sq transformation?
