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 / shake
Its is possible using regular expression in informatica
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
What is deployment group?
how to work with mapplet designer in informatica?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Explain the types of lookup transformation?
How will you check the bottle necks in informatica? From where do you start checking?
What is a router transformation?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Explian the connected and unconnected lookup transformation
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
What are the options in the target session of update strategy transsformatioin?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.