Display optimized sql is not pushdown when we use multiple a

dataservices job design
1

Hi ,

I have source table with owner owner1. source and target table with owner2. target table.

Both are from same database ( SAP IQ). I need to use data store configurations as I need to connect multiple systems.

I have created two aliases one for source tables and another one for target tables.

I created simple data flow with one one mapping and target table without bulk load options.

If I see the display optimized sql it is showing sql statement instead of insert into statement. If I don’t use aliases and import original owner it is showing the insert into statement?

Is any impact of multiple aliases in the data store for puhsdown?

If I am using the multiple aliases, how can I achieve the puhdown?

Thanks & Regards,

Venkata Ramana Paidi.

Ramana :india: (BOB member since 2009-04-30)