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
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 1 comment 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 8 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
Sorting a Hierarchy differently Mark Chinsky 1 comment 0 votes None
Format standard measure to hh:mm format. Jyothi Dosi 2 comments 0 votes None
Custom Data on a table Padarthi, Satish 1 comment 0 votes None