How to use Variables or filter to extract partial records in Data Service

[Former Member]

Hi

We would like to add filter on the data source to extract only some specific range of values. For a huge dataset (around 5M), we only need probably 200 records. Instead of extract the whole 5M records, we need to find a way to apply a filter during or before the extraction. ( The 'where' condition in Query is only do the selection after extraction, which is not what we want)  Pl give me some help on that! Thanks!

RFC connection, ODP object as the extracor to load data from ECC to SQL data mart

[Former Member]

Solved.

[Former Member]

How did you resolve it?

[Former Member]

Create GV and then assign the GV to the colums. Full push down to data source

[Former Member]

another way is to using sql transform and pick only sample data required