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 |
how to create a sample mapping for dynamic lookup transformation
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
can v update d records in target using update stargey without generationg primary key ? explain
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What is a grid in Informatica?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
Define error Threshold?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
What are active and passive transformations?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How/where can i install Informatica software with oracle or teradata as database