SQL & PBI STTM Documentation
Publicada el 2026-07-25
Descripción de la oferta
I’m looking for who can turn my rough notes into a clear, developer-ready Source-to-Target Mapping (STTM) guide that ties together our SQL logic and the Power BI layer. Here’s what I need the finished document to cover: • Table schemas – each source and target table detailed with column names, data types and primary keys. • Field mappings – one-to-one and one-to-many relationships spelled out, including any renamed or derived columns. • Transformation rules – step-by-step logic exactly as it appears in the SQL, with additional explanation where Power BI performs further calculations or measures. Our data warehouse sits in oracle, so please weave Snowflake-specific syntax or nuances into the narrative whenever it matters. The end product should let a new engineer open the document, understand the lineage from raw tables through to the published Power BI dataset, and implement changes confidently.
Skills
Fuente original: freelancer