In "TPC BENCHMARK ™ DS Standard Specification Version 2.3.0", Page 49, there's Data
Maintenance Method 1 description --
Method 1: Fact Table Load
for every row v in view V corresponding to fact table F
get row v into local variable lv
for every type 1 business key column bkc in v
get row d from dimension table D corresponding to bkc
where the business keys of v and d are equal
update bkc of lv with surrogate key of d
end for
for every type 2 business key column bkc in v
get row d from dimension table D corresponding to bkc
where the business keys of v and d are equal and rec_end_date is NULL
update bkc of lv with surrogate key of d
end for
insert lv into F
end for
But what is the bkc for Fact Table or the view? -- As we know only Dimension table has the business
key. And by check all the Business Key column should name with postfix "_id" and for all the DM views
-- I can't find any column named like "..._id" ... And even weird -- there are two kinds of business keys
-- "type 1 business keys" and "type 2 business keys" ... Really confused on this. Would anyone kind help
me out?
Thanks in advance for your help.
Dear all,
Maintenance Method 1 description -- Method 1: Fact Table Load for every row v in view V corresponding to fact table F get row v into local variable lv for every type 1 business key column bkc in v get row d from dimension table D corresponding to bkc where the business keys of v and d are equal update bkc of lv with surrogate key of d end for for every type 2 business key column bkc in v get row d from dimension table D corresponding to bkc where the business keys of v and d are equal and rec_end_date is NULL update bkc of lv with surrogate key of d end for insert lv into F end for
key. And by check all the Business Key column should name with postfix "_id" and for all the DM views -- I can't find any column named like "..._id" ... And even weird -- there are two kinds of business keys -- "type 1 business keys" and "type 2 business keys" ... Really confused on this. Would anyone kind help me out? Thanks in advance for your help.
Regards Eisen