SQL & PBI STTM Documentation
Budget: ₹400 – ₹750 INR
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.
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.