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

Answer Posted / shaik

In target table Change the data type as varchar2()

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

758


How do you migrate data from one environment to another?

730


What are the steps involved in the migration from older version to newer version of Informatica Server?

1687


What are the different types of transformation available in informatica.

725


How to create a non-reusable instance of reusable transformations?

784






How to load a Dimension ? and how to load a fact table?

1044


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1201


What is union transformation in informatica?

802


what is unit testing?tell me proceedure

1881


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1536


Explain sessions. Explain how batches are used to combine executions?

695


define galaxy repository in informatica

1825


Does an informatica transformation support only aggregate expressions?

703


draw informatica architecture 8.6 ?

3547


What is decode in static cache?

685