I just wanted to clarify a few issues
with my designs of a recent model that
i did, can you give me some
recommendations.
I have a 3NF marketing datamart build,
various information feeds from various
credit unions are sent, I build a
staging area to do ETL process, then do
loads to the datamart. I have a
question is that, for example a table
in the policy subject area, called in
policy_1, which contains policy
information such as
(policy_id, expiry_date, premium) and a
customer information table which
contains information such as
(customer_id, household_id, first_name,
last_name, date_of_birth) etc. should
this two tables contains the deltas (a
new row will be inserted only if there
is a change information) or should
repetitive information inserted as well
in every feed? what would you
recommend?
i am using this datamart as a base to
generate various dimension and fact
tables.
EdgarNg
with my designs of a recent model that
i did, can you give me some
recommendations.
I have a 3NF marketing datamart build,
various information feeds from various
credit unions are sent, I build a
staging area to do ETL process, then do
loads to the datamart. I have a
question is that, for example a table
in the policy subject area, called in
policy_1, which contains policy
information such as
(policy_id, expiry_date, premium) and a
customer information table which
contains information such as
(customer_id, household_id, first_name,
last_name, date_of_birth) etc. should
this two tables contains the deltas (a
new row will be inserted only if there
is a change information) or should
repetitive information inserted as well
in every feed? what would you
recommend?
i am using this datamart as a base to
generate various dimension and fact
tables.
EdgarNg