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
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 0 votes 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 1 vote 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