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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is powercenter on grid?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How are indexes created after completing the load process?
What is a dimensional model?
What is the use of target designer?
what is index?how it can work in informatica
What is dimensional table?
What is meant by LDAP users?
Enlist few areas or real-time situations where informatica is required.
Which transformation is needed while using the Cobol sources as source definitions?
What is a node in Informatica?
how tokens will generate?
How do you load unique records into one target table and duplicate records into a different target table?
According to his methodology what all you need before you build a datawarehouse