1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?

Question Posted / pooh

Answers were Sorted based on User's Feedback



IF Sorce table contains CLOB as its one data type then i get error at the target table. How can th..

Answer / shaik

In target table Change the data type as varchar2()

Is This Answer Correct ?    3 Yes 0 No

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can th..

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

Post New Answer

More Informatica Interview Questions

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

What is the use of target designer?

0 Answers  

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

Explain lookup transformation source types in informatica

0 Answers   Informatica,

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,




How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

What is synonym?

2 Answers   Patni,

how to obtain performance data for individual transformations.

2 Answers  

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

How informatica recognizes mapping?

2 Answers   CTS,

what is index?how it can work in informatica

0 Answers  

For more Informatica Interview Questions Click Here
Categories