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
- 2659 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 domain in terms of informatica?
Write the different tools in the workflow manager?
Please let me know how to make Data masking in informatica..
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Separate from an archive server and a powerhouse?
What is informatica etl tool?
What are junk dimensions?
What are the popular informatica products?
To import the flat file definition into the designer where should the flat file be placed?
What are the types of schemas we have in data warehouse.
Informatica Checkpoints
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the informatica workflow?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
