WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
February 12, 2016, 11:32 AM
dimension ETL using DataMigrator, and we are using the AUTOINCREMENT option for Surrogate Keys. We have set the SK column as detailed in the following image:
Hello, For a better analysis of this problem we would like to ask you to open a hottrack case. Please describe the results, and add your flow and synonym files to the hottrack case; additionally please provide the DDL statement for the target synonym.
February 12, 2016, 02:51 PM
After you make changes to the synonym you need to recreate the table to reflect the changes in ORACLE. Right click on the synonym and select Data Management, Recreate DBMS Table. Your user id must have been granted privileges for create table, sequence and trigger. Once you have done this then it's ORACLE that assigns the value to your surrogate key.
February 16, 2016, 12:03 PM
Thanks for your responses. Finally, I was able to find the relationship between AUTOINCREMENT option and Database, because when the table is created from DMC using "Recreate to DBMS" option, it creates a TRIGGER and a Oracle Sequence linked to the SK column that is filled with the Nextval when a new row is added to the table. Problem solved.