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
How many ways are there to create ports?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are ETL Tools?
Enlist the differences between database and data warehouse.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Tell me about Propagate functions in informatica
How to update source definition?
Is there any target staging area in informatica not staging area
what is the Default Source Option For Update Strategy Transformation?
What are the different types of olap? Give an example?
How does a rank transform differ from aggregator transform functions max and min?
Where are the source flat files kept before running the session?
In informatica workflow manager, how many repositories can be created?
lookup transformation with screenshots
What is lookup change?