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
- 6734 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 |
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
What are Dimensions and various types of Dimensions?
How do you handle two sessions in Informatica
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
how to get the only updated records in the target
whats the logic to load the lower level of granularity of data to fact table.
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Explain the different kinds of facts.
what is surrogate id ?
What is InformaticaPowerCenter?
Target is zero file and how can you send the email?
Teradata 
