Below is the query for ODI refresh variable IS_INCREMENTAL in BIApps prebuilt code. I tried searching for What is QUALIFY_DS in this sql, but could not find anything.
Can anyone help on this?
| SELECT | IIF(COUNT(*)>0,'Y','N') |
| FROM | QUALIFY_DS(W_ETL_LOAD_DATES) |
| WHERE | PACKAGE_NAME = 'GET_CONTAINER_NAME()' |
| AND | (DATASOURCE_NUM_ID=#DATASOURCE_NUM_ID |
| OR | DATASOURCE_NUM_ID=#WH_DATASOURCE_NUM_ID) |
| AND | ETL_USAGE_CODE = '#ETL_USAGE_CODE' |
| AND | COMMITTED='1' |
| |
