Hi Team,
May I ask what is/are the counterpart function in BIRST ETL script function for UPDATE?
Thank you for your inputs
When you create a dimensional model in Birst, it is through Scripted Source. In Modeler/Relate, you make a hierarchy with a level key that defines the uniqueness of each row in the hierarchy. In the Scripted Source Output columns, a column will be populated from source data, the unique level key value for the hierarchy. When you assign a hierarchy to an Output Column as an Attribute along with the corresponding hierarchy in Modeler/Relate Model Properties, the hierarchy is populated and associated with the corresponding measure table. The Birst engine checks whether that unique level key exists; if not, then it INSERTs, else it UPDATEs (when any other attribute within the hierarchy changed using a checksum). UPDATE is only applicable to hierarchy processing.
For processing data to a measure table, there are Source Transaction Policies to snapshot data, full refresh, and incremental refresh (with or without delete key). INSERT/DELETE statements are used by these policies.
If you are new to Birst, it is beneficial to take the Foundation: Admin course in Infor U to deeply understand these concepts and other dimensional modeling aspects, as well as ELT (use of connectors and creating staging tables).
