Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


How to load duplicate records in to a target table which has a primary key?

2 Answers  


In warehouses how many schemas are there?

0 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


version controlling in informatica?

3 Answers  


If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  


Categories