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
- 6581 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 |
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
in oracle write query yourname+1 from dual
whether Sequence generater T/r uses Caches? then what type of Cache it is
Where is the cache stored in informatica?
How can you access the remote source into your session?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
The question was on time stamp. what is the difference between HH and HH24 when to use when.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is active and passive transformation?
Design a mapping to get year of join for each employee.
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
can anyone suggest best free Talend data integration training online
Teradata 
