Full push down & Partial push down

[Former Member]

How to check whether my operation is fully pushed down or partially done ?

View optimized SQL is the only way to check whether the operation i am doing is fully pushed down or partially done ? i have the below in

the SAP article which says

Operations within the SELECT statement that the software can push to the

database include:

• Aggregations — Aggregate functions, typically used with a Group by statement, always produce a data set smaller than or the same size as

the original data set.

My doubt here , If i do the opearions like one query transform to just map from my source to target and another query to do the sorting and another one to group by will have a better performace or combining everything in one query transform will have a better performace ??

Thanks,

AJ.

[Former Member]

You are correct - use "View Optimized SQL" to check how much is being pushed down.

The Data Services optimizer attempts to push down as much of the logic from a data flow as possible, so if logic is distributed across a number of query transforms it can still be combined and pushed down.  You can see what is being pushed down by using "View Optimized SQL".