We have six packages that all have SCDC controls running in parallel they create duplicate row(s) in dimension tables, When i create a unique index on the Business Key columns the SCDC control fail...
Id #10368 |
Planned Release:
None
|
Last Updated: Mon at 7:02 AM by jantje_20 |
Created On: Feb 13 at 2:56 PM by chandrasc
I'm havine an issue with the SCD2. I have a dimensions where I want to use SCD2 for any attribute field that changes. In the set up I've identified a surrogate key, business key, SCD2 Effective Dat...
Id #10242 |
Planned Release:
None
|
Last Updated: Jan 26 at 8:30 PM by gbuschmann |
Created On: Jan 26 at 8:30 PM by gbuschmann
Hi! I have 2 inputs - source data and existing dimension data. Source data is sorted by Order by clause. Starting with 1 existing record in dimension (unknown member), so it's first time filling. W...
Id #10174 |
Planned Release:
None
|
Last Updated: Jan 23 at 7:06 AM by Sm1th |
Created On: Jan 19 at 6:33 AM by Sm1th
I have a dimension with mostly SCD2 and one SCD1 column. During a deployment I had a need to add some columns to the dimension table so I set Inferred true on all records as I copied the data into ...
Id #9998 |
Planned Release:
None
|
Last Updated: Dec 16 2011 at 2:56 PM by tlum |
Created On: Dec 14 2011 at 2:29 PM by tlum
I love this tool!
I have a source table that already tracks the begin date and the end date of an employee's status (along with a bunch of other employee information). I want to use the tool for s...
Id #9988 |
Planned Release:
None
|
Last Updated: Dec 12 2011 at 9:26 PM by smadirondack |
Created On: Dec 12 2011 at 9:19 PM by smadirondack
We have been using this wonderful component for a few months now without issue. Unfortunately, today we attempted to run our process for a larger date range than usual. What we end up with was Sour...
Id #9965 |
Planned Release:
None
|
Last Updated: Dec 6 2011 at 5:59 PM by delish |
Created On: Dec 6 2011 at 5:59 PM by delish
Hi,
I cannot select a dt_nummeric field as the surrogate key.
Why is this limitation? can this be fixed or is there an workaround?
thanks in advance,
Ruben
Id #9834 |
Planned Release:
None
|
Last Updated: Nov 16 2011 at 2:13 PM by rtieland |
Created On: Nov 16 2011 at 2:13 PM by rtieland
There is no SCD0 functionality. It would be good to add this feature.
Id #9660 |
Planned Release:
None
|
Last Updated: Oct 17 2011 at 4:03 PM by tlum |
Created On: Oct 17 2011 at 4:03 PM by tlum
Hi guys, we are getting the following error:
Internal error (Object reference not set to an instance of an object.) in ProcessKey, detecting SCD1 and 2 changes in column Customer Id, key: 53007c00...
Id #9593 |
Planned Release:
None
|
Last Updated: Oct 5 2011 at 12:19 AM by 00 |
Created On: Oct 5 2011 at 12:19 AM by 00
- Existing and source inputs both SQL Server
- Source table unchanged since last run
- v1.6 Dimension Merge SCD Component used
- Configured for mixture of SCD1 and SCD2
When executing in the above...
Id #9413 |
Planned Release:
None
|
Last Updated: Oct 19 2011 at 7:33 AM by talwar_ |
Created On: Aug 25 2011 at 2:12 AM by leemoran
|
|
|
|
|