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

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1476


Where can we find the throughput option in informatica?

610


Suppose we do not group by on any ports of the aggregator what will be the output?

588


What are the issues you have faced in your project? How did you overcome those issues?

1925


Tell me about MD5 functions in informatica

532






How will the document be delivered to me?

627


Different qualification between a related rotate toward the sky and isolates look upward?

564


What is enterprise data warehousing?

621


What is union transformation?

581


What is the benefit of partitioning a session?

645


can we override a native sql query within informatica? Where do we do it? How do we do it?

606


What is confirmed fact in dataware housing?

5705


How can we delete duplicate rows from flat files?

756


What is rank index in rank transformation?

615


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

706