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 |
Is it possible to define a single node as a Gateway node as well as worker node?
How do you handle decimal places while importing a flatfile into informatica?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
What is the commit type if you have a transaction control transformation in the mapping?
During the running session, output files are created by informatica server. Enlist few of them.
How to load duplicate records in to a target table which has a primary key?
In warehouses how many schemas are there?
Normalizer transformation is not involved in Mapplet.. why???
version controlling in informatica?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What are the guidelines to be followed while using union transformation?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision