What is QULIFY_DS in IS_INCREMENTAL ODI variable in BIApps prebuilt code

3058163

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'

Thomas Dodds

Is your incremental not running properly?

Venkata Yaswanth Ramisetty

Hi,

This will just returns the complete name of a physical object, including its catalog and schema name. If you open this function, the implementation syntax will be <%=odiRef.getObjectName("L","$(VALUE)","D")%>. So, it will just get object name. For more info, you can refer getObjectName()

Thanks,

Yaswanth

3058163

Thanks Venkata