Hi
I am finding that when I move an Extractor within a DataFlow, SAPDS regenerates the code for the data flow and this leads to some Selection parameters not always being pushed down.
Example:
Data flow contains Extractor > Query > Target Table
Query contains WHERE clause:
FIELD1 = VALUE1
AND FIELD2 = VALUE2
AND FIELD3 = VALUE3
When I check the generated code (Tools > Validate SQL) I can see the 3 fields being pushed down as Selection parameters. When I run the job, I see the selection begin used in ECC (t-code ODQMON) i.e. 3 fields used as filters
Issue:
if I edit the dataflow, and specifically move the Extractor source within the screen, the newly generated code only push down “some” of the parameters e.g. FIELD1 and FIELD2 but FIELD3 is no longer pushed down. the real problem is that I can (so far) never get back to the optimum 3 fields pushdown
Not sure why this behaviour occurs. There are no change on the ECC side.
I tried to look at the column properties in the Extractor metadata and set the Selection Mandatory flag to “yes” but this did not change the behaviour described above.
Anyone else experienced inconsistent “push down” behaviour with SAP DS extractors?
I am using SAP DS 4.1 SP2
Nicolas Hadj-Blaha (BOB member since 2005-03-10)