Start and end dates in a snapshot table
Give this one a try later!
Represent the ETL dates during which a row's snapshot data was valid.
Where is referential integrity not enforced in Caboodle?
Give this one a try later!
FilteredAccess Schema since it's already a filtered database
If a join is from a primary key column TO a lookup column, what join type should you
use?
,Give this one a try later!
Outer
What does joining to a bridge table do to the granularity of your results?
Give this one a try later!
Increases granularity since bridge tables map a "to‐many" relationship
How can you find all the data models that can use a certain filter record?
Give this one a try later!
Search Record Viewer for FDS 1500
Data Lineage
Give this one a try later!
Part of the Data Dictionary that shows which Clarity column is used to
populate the Caboodle column
What does the Cogito data dictionary reflect?
Give this one a try later!
, The dbo schema
Dependencies
Give this one a try later!
Part of the Data Dictionary that shows you what database objects a table is
dependent on (usually Clarity tables but could be other Caboodle tables)
Examples of EAV tables that don't end in the usual suffix
Give this one a try later!
FlowsheetValueFact
LabComponentResultFact
Inferred row values
Give this one a try later!
primary key = positive number
lookup columns = -1
A lookup column in CB contains the value -3. What could this mean?
Give this one a try later!
, 1. The data that once populated this row has been deleted
2. This is the row with -3 as its primary key (all lookup columns = -3)
If primary key is non-negative then option 1
Where is referential integrity NOT enforced?
Give this one a try later!
FilteredAccess Schema
TEST: Why do fact tables have so many lookup columns?
Give this one a try later!
Point to dim tables that store information about the entities
TEST: T/F If a datapoint exists in Clarity but not in Caboodle, your Caboodle
developers can create a custom SSIS package to extract the data point to Caboodle
Give this one a try later!
True
How do you identify a snapshot table?
Give this one a try later!
Represent the ETL dates during which a row's snapshot data was valid.
Where is referential integrity not enforced in Caboodle?
Give this one a try later!
FilteredAccess Schema since it's already a filtered database
If a join is from a primary key column TO a lookup column, what join type should you
use?
,Give this one a try later!
Outer
What does joining to a bridge table do to the granularity of your results?
Give this one a try later!
Increases granularity since bridge tables map a "to‐many" relationship
How can you find all the data models that can use a certain filter record?
Give this one a try later!
Search Record Viewer for FDS 1500
Data Lineage
Give this one a try later!
Part of the Data Dictionary that shows which Clarity column is used to
populate the Caboodle column
What does the Cogito data dictionary reflect?
Give this one a try later!
, The dbo schema
Dependencies
Give this one a try later!
Part of the Data Dictionary that shows you what database objects a table is
dependent on (usually Clarity tables but could be other Caboodle tables)
Examples of EAV tables that don't end in the usual suffix
Give this one a try later!
FlowsheetValueFact
LabComponentResultFact
Inferred row values
Give this one a try later!
primary key = positive number
lookup columns = -1
A lookup column in CB contains the value -3. What could this mean?
Give this one a try later!
, 1. The data that once populated this row has been deleted
2. This is the row with -3 as its primary key (all lookup columns = -3)
If primary key is non-negative then option 1
Where is referential integrity NOT enforced?
Give this one a try later!
FilteredAccess Schema
TEST: Why do fact tables have so many lookup columns?
Give this one a try later!
Point to dim tables that store information about the entities
TEST: T/F If a datapoint exists in Clarity but not in Caboodle, your Caboodle
developers can create a custom SSIS package to extract the data point to Caboodle
Give this one a try later!
True
How do you identify a snapshot table?
