Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 11571 Views
- Accenture, I also Faced
- E-Mail Answers
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
What is the function of look up transformation?
What are the data movement modes in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is difference between a gateway node and worker node?
What is union transformation?
What is sorter transformation?
What is persistent lookup cache?
State the limitations where we cannot use joiner in the mapping pipeline?
What is resilience time?
How does a sorter cache works?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What could be the possible resons of locks by user?
What is a sequence generator transformation?
