IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?

Answer Posted / sandeep

When a CLOB datatype is pulled in Informatica,that port in Source Qualifier should be converted to String datatype and propagate the same till the target.
It works then.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pmcmd command usage in informatica

695


In informatica workflow manager, how many repositories can be created?

772


How to handle decimal places while importing a flatfile into informatica?

710


What do you understand by term role-playing dimension?

563


How to create a non-reusable instance of reusable transformations?

668






How can we update a record in the target table without using update strategy?

645


To import the flat file definition into the designer where should the flat file be placed?

666


What are the different types of repositories created using informatica?

649


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1640


How many ways are there to create ports?

715


What are the issues you have faced in your project? How did you overcome those issues?

1908


Define filter transformation?

614


Sequence generator, when you move from develoment to production how will you reset

1395


What is exclusive and normal mode for repository services?

706


What is an expression transformation?

583