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 / davan

In expresion t/r just give data type as string only...

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to create multiple domains on a single Informatica server?

869


What is the difference between STOP and ABORT options in Workflow Monitor?

802


Explain about Informatica server process that how it works relates to mapping variables?

714


How to Create a folder using pmrep command?

712


What are the components of the workflow manager?

749






Explain dynamic target flat file name generation in informatica

732


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1716


Differentiate between reusable transformation and mapplet.

700


What is a connected transformation?

782


What is main use of mapplet?

760


What is repository manager?

632


What is informatica? Why do we need it?

743


What is substr in informatica?

790


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1624


What the difference is between a database, a data warehouse and a data mart?

685