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
What is rank transformation in informatica
what is Active lock explain
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What does update strategy mean, and what are the different option of it?
What is joiner change?
What do you mean by worklet?
Briefly explain the aggregator transformation?
What is joiner transformation?
What is sq transformation?
What is a stored procedure transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the use of target designer?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the sql query overwrite in source qualifier in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?