Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
What is QULIFY_DS in IS_INCREMENTAL ODI variable in BIApps prebuilt code
3058163
Rank 1 - Community Starter
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' |
0
Answers
-
Is your incremental not running properly?
0 -
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
0 -
Thanks Venkata
0