Hi, Decision Stream experts
Please assist in any of the following problems:
1. I want to build a dimension where the primary key (business key) will be generated (Max[primary key] + 1) only when new rows are inserted,
2. I am looking for a way to have conditions on UPDATE/INSERT for example:
UPDATE MATERIAL WHEN MATERIAL_LIFE.CREATION_DATE > MATERIAL_SMART.CREATION_DATE
ELSE INSERT NEW RECORD.
I haven't find a way to solve these yet. Please advice...
Please assist in any of the following problems:
1. I want to build a dimension where the primary key (business key) will be generated (Max[primary key] + 1) only when new rows are inserted,
2. I am looking for a way to have conditions on UPDATE/INSERT for example:
UPDATE MATERIAL WHEN MATERIAL_LIFE.CREATION_DATE > MATERIAL_SMART.CREATION_DATE
ELSE INSERT NEW RECORD.
I haven't find a way to solve these yet. Please advice...