Home » Developer & Programmer » Data Integration » Type 2 in OWB
Type 2 in OWB [message #93375] Fri, 01 October 2004 09:41
Mike Smith
Messages: 3
Registered: January 2002
Junior Member
We are unable to successfully implement a type 2 scd as illustrated in the OWB document called "B12151_01.pdf".

It uses a splitter and merge task to facilitate the addition of a type 2 record. In addition, the example adds a column called "MATCHING" so that the update can be done against a preexisting surrogate key.

The problem we are having is that we cannot seem to populate the "MATCHING" column and the update fails. There is a comment in the documentation that the "MATCHING" column should be bound to the surrogate key column. However, the bound name property is read only and cannot be changed.

Thanks in advance for your help.

Previous Topic: a design problem(dimensional model)
Next Topic: Invalid Rowid
Goto Forum:

Current Time: Thu Dec 09 06:43:23 CST 2021