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
What are mapplets? How is it different from a Reusable Transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain sessions?
What is resilience time?
How to load a Dimension ? and how to load a fact table?
write a query to retrieve the latest records from the table sorted by version(scd)
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain transaction control transformation in informatica
Explain the pipeline partition with real time example?
What is meant by query override?
What is the procedure for creating independent data marts from informatica 7.1?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the components of workflow manager?