Data Modeling & Transformation

New post

Questions around Table & Schema Design, Facts vs Dimensions, Data transformations, Lookups, Table Inserts, Add Related Records, Hierarchies, Pivoting Data, Primary Keys, Relations, Bridge Tables etc.

Show all All Planned Not planned Completed Answered No status Sort by newest post Newest post Recent activity Votes Comments
Are "Over Ride Data Types" applied in order like a SQL case statement? Brandon Spencer 0 comments 0 votes None
Solutions for different schemas in a data lake? Brandon Spencer 6 comments 0 votes None
Converting int/char to date Gediminas 6 comments 0 votes Completed
Incremental Table insert - Is it possible? Bas Hopstaken 2 comments 0 votes Answered
Relationship between 2 tables (left outer join) Roland Peeters 1 comment 0 votes None
Default column value for simple tables in BU / ODX Server Ben van der Helm 5 comments 0 votes None
Add related records, no relation between tables Martin Larsson 3 comments 0 votes None
Primary key violation - which record is then valid ? Torben Kylling Petersen 1 comment 0 votes Completed
Deadlock on sys.tables Josiah Norton 9 comments 0 votes None
Working with Table Inserts Greg Laymon 2 comments 0 votes Answered
Partition Scheme Anders T. Grønlund 3 comments 0 votes None
converted to type nvarchar Rajneesh Mangotra 2 comments 0 votes None
Table classification Alexander Hauenstein 3 comments 0 votes Answered
Clustered columnstore index Per Scheffer 2 comments 0 votes None
Two datasources into one table Keith Williams 7 comments 0 votes None
Setting a flag when execution is done Michael Vaisgaard 2 comments 0 votes None
Use IS NOT NULL as a join condition on lookup Mark Ferris 15 comments 1 vote None
CASE WHEN Michael Vaisgaard 2 comments 0 votes Answered
Securing sensitive data Eric van Gemert 0 comments 0 votes None
Can you protect your project from piracy? Mark Chinsky 4 comments 1 vote None
SQL 'Case' sai krishna mamidi 1 comment 0 votes None
Normalizing table containing filed in json format Hansen, Mikkel Hecht DK - NOH 1 comment 0 votes None
How to create a transformation that is different for each mapping going to the same table Steven Koppenol 5 comments 0 votes None
How can a parent-child hierarchy be historicized using parent DW_Ids? Dennis Ritz 1 comment 1 vote None
database diagram: visualize your data model Dror Svartzman 6 comments 1 vote None
Many to many Relations and condinonal joins José Hoyos 3 comments 0 votes None
Filtering on the Look up fields Banerjee, Supriyo 4 comments 0 votes None
Using Collate on Join conditions Banerjee, Supriyo 4 comments 0 votes None
How to RoundUp or RoundDown Decimal Ghazy 2 comments 0 votes None
Conditional Lookup multiple values Hendrik Gruß 1 comment 2 votes None