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
- 2524 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 is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the advantages of informatica?
What is expression transformation?
Mention some types of transformation?
what is the Default Source Option For Update Strategy Transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is exclusive and normal mode for repository services?
Different qualification between a related rotate toward the sky and isolates look upward?
What are data-driven sessions?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
COM components can be used in Informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can u generate reports in Informatica?
What is a sequence generator transformation?
Explain what is informatica metadata and where is it stored?
