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
- 2504 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 settings that you use to configure the joiner transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Under which circumstances, informatica server creates reject files?
Differentiate between sessions and batches?
What are the mapping parameters and mapping variables?
is it possible to index the data in cache of lkp transformation ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the difference between a connected look up and unconnected lookup?
what is diff b/t sorter t/r and agg have the option sorter property...
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Is there any way to read the ms excel datas directly into informatica?
Explain target update override in informatica
