Question
Scenario: When a BI environment is being loaded with historical transactions (as a factual detail) an existing customer dimension record may be referenced for setting
Scenario: When a BI environment is being loaded with historical transactions (as a factual detail) an existing customer dimension record may be referenced for setting a value as a foreign key on a fact table. Some of these statements about a CUSTOMER dimension table are true. Others are suspect. Check only those that make sense.
A CUSTOMER record should only be inserted into a customer dimension after at least a first transaction has been processed in a source application database.
A CUSTOMER record is often inserted for any person or business that is expected to conduct business with a company.
A CUSTOMER record is subject-oriented, non-volatile, time relevant evidence that financial activity has taken place.
A CUSTOMER record is recognized whenever activity originating in an operational source application. If missing, a new customer record must be insert before the fact record can be processed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started