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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain the etl program with few examples.
How we can create indexes after completing the loan process?
what are the deliverables?in your project?
How to load data in informatica ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you take back up of repository?
can we override a native sql query within informatica? How do we do it?
Explain how many types of dimensions are available in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What does role playing dimension mean?
Explain what is informatica metadata and where is it stored?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the different kinds of facts.