monthsBetween function inconsistant
monthsBetween function (months difference between two dates) is considering mid of the month as a month completion instead of end of the month as a month. any ideas how to correct this?
Forum Posts
error in sparl SQL
Hi ,If i comment NULL as TRX_PERIOD, NULL AS applied_period, mv is loading successfully, uncomment getting below error.Please let me know what is the issue in the query
Schema from load plan stuck in queue
If a certain schema is stuck in queue and the stuck load run was part of a load plan , run below queries in metadata db against JOB and load_plan tables:JOB table: SELECT * from 'JOB' where GUID='0b768a92-d84c-4b65-be4e-f5490702d85a'; UPDATE JOB Set...
Incremental Load
HiIn my project Incremental load implemented in two ways.Some tables implemented as below. Some tables implemented as below. Please confirm which one is correct or both are correct.
Resolved! Excel Plug in for incorta
did someone try download this url - https://<INCORTA_HOST>/incorta/external-add-ins/excel/#/download-manifest, is this working?
