Srinivasa Reddy Munagala

Hello All,

We are using SAP SDI 2.5.2, Oraclelogreader adapter to connect to Oracle. Product - SAP Commissions.

There is a table with more than 3 billion records. Table has a time field EXTRACT_DATE where filters can be applied to fetch data incremental way.

Observation:

Working scenario, where filter push down is working when checking M_REMOTE_QUERY_STATISTICS table REMOTE_STATEMENT_STRING

1. SELECT * FROM “VT_TABLES" where TRX_ID = 1443034440977; Filter push down is OK

2. SELECT TOP 100 * from "_TABLES" where "CREATION_DATE" = '2020-07-30'; Working fine, TOP removed not working.

Not Working Scenario: EXTRACT_DATE of type TIMESTAMP

2. SELECT TOP 10 * FROM VT_TABLES where EXTRACT_DATE = TO_TIMESTAMP('2023-06-01 01:19:22','YYYY-MM-DD HH24:MI:SS'); —WITH TOP 10 AND =

3. SELECT * FROM VT_TABLES where EXTRACT_DATE >= TO_TIMESTAMP('2023-06-01 01:19:22','YYYY-MM-DD HH24:MI:SS'); —WITH >=

When checked REMOTE_STATEMENT_STRING it is NULL and REMOTE_STATEMENT_STATUS is EXECUTING, but data transfer is not happening. When checked remote source capability CAP_BI_TO_TIMESTAMP is available too.

Question is filter on TRX_ID is working, but filter on TIMESTAMP fields is not going fine - this case not only filter push down but data fetch also not going fine.

Thank you in advance!