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 / kamlesh mishra
Use is_number(field) and not is_number(field) functions in router transformations
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose we do not group by on any ports of the aggregator what will be the output?
Please let me know how to make Data masking in informatica..
What is dynamic cache?
What will be the approach?
What are the new features of informatica 9.x developer?
where to store informatica rejected data? How to extract the informatica rejected data?
How do you use reject loader.
server hot-ws270 is connect to Repository B. What does it mean?
what is the size of u r source(like file or table)?
What is a router transformation?
What is session task and command task?
Explain informatica architecture - version 8 / 9
Define mapplet?
What do you mean by blocking transformation?
What are active and passive transformations?