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



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

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


what is shared Cache. when we will use shared Cache?

4 Answers  


split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


whatis the default data driven operation in informatica

2 Answers  






following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,


i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,


How the facts will be loaded? explain

2 Answers   HCL,


What is up date strategy and what are the options for update strategy?

2 Answers  


where to store informatica rejected data?

0 Answers  


How to implement security measures using repository manager?

0 Answers  


COM components can be used in Informatica

0 Answers  


Categories