CODEWITHSUNDEEP
informaticainformatica-powercenter
nithin
nithin

Reputation: 49

In my mapping i have two filter transformations and two target tables but target object writing data into first target and second target is empty

enter image description hereI have one source and two target tables without Primary key. both source and targets are Oracle database. i created a mapping using two filter transformations to load data into two target tables. in both Filter Txn's same condition given i.e., Sal>1500 which satisfies 7 records. When i ran the workflow by keeping target load type 'Bulk' and in run properties it shows 7 records are loaded into each target table but when i check in oracle data base only second table data getting loaded. when i change the Load type to 'Normal' both tables are loaded. what makes the difference in database ?

Upvotes: 1

Views: 372

Answers (1)

Koushik Roy
Koushik Roy

Reputation: 7387

For oracle, bulk load succeeds when there is no index on the table in database. So, when you are running in bulk mode, load to one target is failing because it has index on it in database.
Mode Normal will work with or without index so its working properly.

Upvotes: 0

Related Questions