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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is mapping debugger?
What is the fact table?
What is update strategy transform?
What are the different versions of informatica?
Is stop and abort are same in informatica?
Informatica Checkpoints
Write the unconnected lookup syntax and how to return more than one column.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What do you understand by term role-playing dimension?
Define mapplet?
What is Session and Batches?
What is status code in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?