Thursday, September 30, 2010

Informatica not able to load on a table having index?


Assume your target is Oracle, and your table has primary key and index.

When we try to insert data from informatica to table, Informatica gets
Oracle error saying that index exists on the table not able to load.

If you then try to drop the index Oracle doesnt allow you drop
index created on primary key.

To come out from this problem
Way 1:
==================================
In this case , we need to disable informatica Bulk load option

we can see this option in Task properties window (double click task) -> Mapping
tab . and then select target table from left panel. we will see target load
type

Way 2:
=====================================
Disable Parallel load option from oracle
connection. we can see this options when
creating connection in workflow manager

1 comment:

  1. Informatica Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/informatica-online-training-31.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Informatica Online Training, Informatica Training, Informatica, Informatica Online Training| Informatica Training| Informatica| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete