on 04-28-2016 10:41 PM
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!
CC
Use JOIN : Load the key values in another table and join with your source table.
Example : You have a table with 5m address records but you are interested in countries US ,AU and SG. Place these country codes in a separate table and join with the main to table to filter out the records.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Magesh,
Thanks for your reply. My resource is ODP object from ERP, instead of tables. 'Load the key values in another table' , is it going happen in Data Service? Our case is, in ERP, RSA6, I checked a few columns as 'selection'. And then , we would like somewhere in data service I could set specific values for those columns and then just read data set based on those values. Should I use global variable?
Source is the ODP object import from ERP via RFC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why do you not want to use WHERE?.Explain.
Use JOIN : Load the key values in another table and join with your source table.
Example : You have a table with 5m address records but you are interested in countries US ,AU and SG. Place these country codes in a separate table and join with the main to table to filter out the records.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Whats your Source Database
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.