My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Answer Posted / vijaya
By using function isnumber(), is string() in expression editot you get the solution
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can you differentiate between powercenter and power map?
What is an expression transformation in informatica?
How can informatica be used for an organization?
can you please explain me pre session and post session options?
how many types of dimensions are available in informatica?
In informatics server which files are created during the session rums?
Define mapplet?
What is decode in informatica?
draw informatica architecture 8.6 ?
According to his methodology what all you need before you build a datawarehouse
How to do unit testing in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain sessions?
What differs when we choose the sorted input for aggregator transformation?