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
What is a standalone command task?
How we can use union transformation?
Why sorter is an active transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What are data-driven sessions?
What is an unconnected transformation?
what is informatica metadata?
How can we store previous session logs?
What is meant by active and passive transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Informatica settings are available in which file?
How many number of sessions can one group in batches?
What are the different clients of powercenter?
What is union transformation?
What are the new features of informatica 9.x in developer level?