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 |
any body can say about all versions of informatica ?how many versions ?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Explain direct and indirect flat file loading (source file type) - informatica
Informatica settings are available in which file?
What are the parts of Informatica Server?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Define pmcmd command?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
In which scenario did u used Mapping variable?
explain abt joiner t/r?
how to get the only updated records in the target