SCD开始和结束日期
我是SSI的新手，当我们使用SCD Dimension向导时，我对SCD_START_DATE和SCD_END_DATE感到有些困惑。在我在线搜索的许多示例中，人们总是使用“系统启动时间”或“系统容器”开始时间。但是我正在从头开始实施数据仓库，但是我们的公司有来自两三年前的多个数据源。因此，当我运行包装后，当我将数据源从这两年上传到我们的DW中时，显然会表明，例如，卖方（卖方维度）从我运行该包装的当天更改了，但这是错误的，因为我想要要具有数据源中的参考日期（每行都有一个data_ref）。这不是逻辑还是我错过了什么？您在BI中如何使用参考日期上传旧数据源？
I am new to ssis and i am a little bit confused about the SCD_Start_Date and SCD_End_Date when we use the SCD dimension wizard. on many examples that i have searched online people always use the "system start time" or "system container " start time. but i am implementing a data warehouse from a scratch but our company have multiple data sources from two or three years ago. so when i upload our data source from these two years into our dw after running the package it will obviously show that, for example, a seller (seller Dimension) changed from department in the day i ran that package but this is wrong because i want to have a reference date that is in the data source (each row has a data_Ref) . isn't this the logic or am i missing something? how do you guys in BI upload old data source with a reference date?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SCD开始和结束日期是记录版本的日期（或停止）在您的源系统中的当前版本 - 当数据之间移动数据时，它们无关（除非该动作是交易的一部分，否则改变了记录的状态）。
展望未来，创建新的SCD记录相对容易，并且您每次源系统都会发生更改时插入新版本的记录（并更新记录的先前版本）。
加载历史数据完全取决于您的源系统。如果它仅保留记录的当前版本，则只能将单个版本加载到DWH中。如果源系统包含所做更改的历史记录（或者，例如进行更改的审计踪迹），则您应该能够以使您可以将记录的多个版本加载到中的方式中重新构造历史记录您的DWH
SCD Start and End dates are the dates that a version of the record became (or stopped being) the current version in your source system - they have nothing to do with when data was moved between environments (unless that movement was part of a transaction that changed the state of a record).
Going forward, it is relatively easy to create new SCD records and you insert a new version of a record (and update the previous current version of the record) every time there is a change in the source system.
Loading historic data is entirely dependent on your source system. If it only holds the current version of a record then you can only load that single version into your DWH. If the source system, contains a history of the changes made (or, for example, an audit trail of changes made) then you should be able to re-construct the history in a way that allows you to load multiple versions of a record into your DWH