Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

WID syncs change when FACT table updates

Received Response
31
Views
2
Comments
Brian666H
Brian666H Rank 6 - Analytics & AI Lead
in Oracle Analytics Cloud and Server

Summary

When we update a FACt table we lose our WID links with DIM Table

Content

When we update a FACT table we lose our WID links with DIM Table in DVD

Version

18 , Cloud

Tagged:

Answers

  • RichardChan
    RichardChan Rank 6 - Analytics & AI Lead

    Check that you are not truncating and reloading your Dimensions if you are using a sequence to populate your WID then you will be out of synch, use an insert/update strategy

  • Brian666H
    Brian666H Rank 6 - Analytics & AI Lead

    Correct