Hi,
We are creating a fact build to load data from AS400. This is Star Schema Data Mart. We have linked all dimensions and measures to the target. However, in the target table which is our fact we have a column called Fact_key.
This column needs to be populated with the row id which needs to be populated incrementally whenever a new record is added to the fact....meaning for the first record the Row Id would be 1, for the next record it should get incremented to 2 and so on.
The fact is an insert else update fact.
Can u pls suggest how this would be handled in decisionstream.
Rgds
RajDat
We are creating a fact build to load data from AS400. This is Star Schema Data Mart. We have linked all dimensions and measures to the target. However, in the target table which is our fact we have a column called Fact_key.
This column needs to be populated with the row id which needs to be populated incrementally whenever a new record is added to the fact....meaning for the first record the Row Id would be 1, for the next record it should get incremented to 2 and so on.
The fact is an insert else update fact.
Can u pls suggest how this would be handled in decisionstream.
Rgds
RajDat