Interested to Buy Any Domain ? << Click Here >> for more details...
IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?
- 2 Answers
- 6680 Views
- I also Faced
- E-Mail Answers
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 |
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
I have 1200 records how can u send it in aggregator with good performance issues?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What are the tasks that can be performed using sq?
How u use pdf file in informatica source?
How do you load unique records into one target table and duplicate records into a different target table?
What are the diffrences between joiner transformation and source qualifier transformation?
What is the need of an ETL tool?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is the Process to creating lookup transformation in informatica
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Teradata 
