Skip to Content
-1

Time dependent Master data via History tables.

Jun 06, 2017 at 08:27 AM

71

avatar image
Former Member

Hi All,

I was looking for the best way to capture historical data in HANA for master data tables without the VALID_TO and VALID_FROM fields.

From my understanding, we have 2 options here.

1. Create a custom history table and run a stored procedure that populates this history table from the original table. Here we compromise with the real-time reporting capability on top of this table.

2. Enable the History table flag in SLT for this table so that SLT creates this as a history table which solves this problem.

Option 2 looks like a clear winner to me but I would like your thoughts on this as well.

Let me know.

Thanks,

Shyam

10 |10000 characters needed characters left characters exceeded

When you invest the effort and do some search for 'history table' here on SCN you should find some rather elaborate discussion and the answer to why option 2) is not a great idea at all.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers