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
- 11799 Views
- Accenture, I also Faced
- E-Mail Answers
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
How to load the data from a flat file into the target where the source flat file name changes daily?
In informatics server which files are created during the session rums?
What is the need of an ETL tool?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is resilience time?
What are the types of schemas we have in data warehouse.
What is the need of etl tools?
Is there any way to read the ms excel datas directly into informatica?
What are some examples of informatica etl programs?
Does an informatica transformation support only aggregate expressions?
Where are the source flat files kept before running the session?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
without table how to come first record only in oracle?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
