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
Explain pmcmd command usage in informatica
In informatica workflow manager, how many repositories can be created?
How to handle decimal places while importing a flatfile into informatica?
What do you understand by term role-playing dimension?
How to create a non-reusable instance of reusable transformations?
How can we update a record in the target table without using update strategy?
To import the flat file definition into the designer where should the flat file be placed?
What are the different types of repositories created using informatica?
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
How many ways are there to create ports?
What are the issues you have faced in your project? How did you overcome those issues?
Define filter transformation?
Sequence generator, when you move from develoment to production how will you reset
What is exclusive and normal mode for repository services?
What is an expression transformation?