sdoubleday scdtype6generator issues

sdoubleday / scdtype6generator

You write the source object. This emits the rest of your Type 6 Slowly Changing Dimension SQL code

MIT License

0 stars 0 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Remove block comments from postupgradeinitialization script that are breaking parsing

#118 sdoubleday closed 2 years ago
0
Can I use Scriban to better handle the templating?

#117 sdoubleday opened 2 years ago
1
T1 table needs defaults to support new column deployment

#116 sdoubleday closed 3 years ago
0
A review-batch table

#115 sdoubleday opened 3 years ago
0
Need an activity logger table and sproc

#114 sdoubleday opened 3 years ago
1
Post-upgrade initialization for SNK and T1

#113 sdoubleday closed 3 years ago
1
remove the now-deprecated copycurrent sproc

#112 sdoubleday closed 3 years ago
0
Convert the copycurrent table to a T1 dim

#111 sdoubleday closed 3 years ago
1
Re add the SNK to tables and backend objects

#110 sdoubleday closed 3 years ago
1
Dim attrib default constraints - should they be uninitialized before GETDATE() ?

#109 sdoubleday closed 3 years ago
0
Add default constraints

#108 sdoubleday closed 3 years ago
0
Add rowversion to dimension tables

#107 sdoubleday closed 3 years ago
0
Need to fix copy-on-build thing in csproj to only target .sql files

#106 sdoubleday opened 3 years ago
0
generator utility REALLY needs an example script in a readme

#105 sdoubleday closed 3 years ago
0
Needs the sql scripts copied into the executable directory

#104 sdoubleday closed 3 years ago
0
find a new name for LineProcessorConfig.perLineSubstitutions

#103 sdoubleday opened 3 years ago
0
Roleplaying dimension support

#102 sdoubleday closed 1 year ago
1
Snowseed feature

#101 sdoubleday opened 3 years ago
1
ismissing should always be reset for the unknown member

#100 sdoubleday closed 3 years ago
0
Add column to dimensions for simple filtering in/out or grouping of unknown member

#99 sdoubleday closed 3 years ago
0
Feature flag generator

#98 sdoubleday closed 1 year ago
2
Fix regression bug from the ParsedArgs class

#97 sdoubleday closed 3 years ago
0
missingmember sproc should UPDATE the missingmember text if the row already exists IF @Force = 1 is specified

#96 sdoubleday closed 3 years ago
0
Need a ParsedArgs class

#95 sdoubleday closed 3 years ago
0
Meta-sproc in dimensionSchema: run all dimension loads

#94 sdoubleday opened 3 years ago
0
Pair up parameters for dimension and output path

#93 sdoubleday opened 3 years ago
0
Parameter and replacement code for the MissingMember text default value

#92 sdoubleday opened 3 years ago
0
Step 5 error checking sproc not on list of files in the calling code

#91 sdoubleday closed 3 years ago
0
SKP function broken for multiple NKs - need to fix comment joinstring

#90 sdoubleday closed 3 years ago
0
Test that predim validation failures stop orchestration but do not rollback the predim prep

#89 sdoubleday opened 3 years ago
0
skp function data types out of alignment

#88 sdoubleday closed 3 years ago
0
fix the join in the step 2 prep view

#87 sdoubleday closed 3 years ago
0
Check predim for Ctl_EffdctiveDate <current max effective date

#86 sdoubleday opened 3 years ago
0
If dimSrc_stg does not have Ctl_EffectiveDate then add it to the copy in our output

#85 sdoubleday opened 3 years ago
0
Check predim for any NKs that map to SKs with negative numbers and error out if found

#84 sdoubleday opened 3 years ago
0
Put SNK back in

#83 sdoubleday opened 3 years ago
0
Bug: clear the copy current table each run

#82 sdoubleday closed 3 years ago
1
NK data types need attention

#81 sdoubleday closed 3 years ago
0
Check predim table for multiples of the same NKs and error out if found

#80 sdoubleday closed 3 years ago
0
Insert idempotent of missing key member

#79 sdoubleday closed 3 years ago
1
Output all files to the same path, not three different ones, by splitting on dot at referenced code line

#78 sdoubleday closed 3 years ago
0
skip the delete command in SamplePeople_dimSrc_clearTables_usp if source is not a table (maybe print a note about that, instead)

#77 sdoubleday closed 3 years ago
1
Add parameter to calling code for dimensionSchema

#76 sdoubleday closed 3 years ago
0
natural key columns in select lists now sometimes do not have the commas they need

#75 sdoubleday closed 3 years ago
1
make this list of files dynamic

#74 sdoubleday closed 3 years ago
0
add a sql template for a scalar valued function that takes the NKs and an effective date

#73 sdoubleday closed 3 years ago
5
rename the dimension object from Dim_templateDimCoreName to templateDimCoreName_Dim

#72 sdoubleday closed 3 years ago
0
move the line-level replacement logic into a SCDType6Generator class

#71 sdoubleday closed 3 years ago
0
rename templateSchema as logicSchema, and also in replacement in the calling code

#70 sdoubleday opened 3 years ago
0
move the dimension table to the dimensionSchema

#69 sdoubleday closed 3 years ago
0