Hello everyone,
I'm using SAP Data Services and I have a very simple data flow that reads an Oracle table,
chooses 8 fields and writes to another Oracle table. Both tables are in the same Data Base BUT IN DIFERENT schemas.
All the Data flows I have like this push down to the DB. Data Services creates the insert /*+ append*/ select ... statement.
This specifically does not do the push down... it does the select from the source table and the insert into the target using Data Services.
Push-down data flows can insert 15Millions records in 2 minutes. This Data flow takes 10 minutes to make 10M insertions.
Does anyone have any ideas about what is preventing DS to create the insert /*+ append*/ statement?
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.