Optimzed SQL

[Former Member]

Hi ,

My source and target tables belongs to same data store and when i do Validation - > Check optimized SQL , I am not getting the full optimized SQL .

( Insert Into is missing ).  I am just doing an query operation and it has a single where clause .

Am i missing anyting here ?

Thanks,

AJ

[Former Member]

Hello

The bulk loader can turn off full pushdown, check the target table.

Michael

[Former Member]

I dont have the bulk loader enabled .

Thanks,

Arun.

[Former Member]

what is the database type of the Datastore ?

[former_member187605]

Are you using a function that cannot be pushed down to the database? An implicit type conversion?

Check for more ideas.

[Former Member]

Its just a query transorm and i am just using a where clause on a field to filter blank values.

Thanks

Arun.

[former_member187605]

Varchar field?