IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?
Answers were Sorted based on User's Feedback
Answer / shaik
In target table Change the data type as varchar2()
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How identifying bottlenecks in various components of informatica and resolving them?
What is Index Caches size?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
How Union Transformation is an Active Trans?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What is Target Update Override? What is the Use ?
how can we run workflow with pmcmd?
In informatics server which files are created during the session rums?
How to load duplicate records in to a target table which has a primary key?