Caboodle: CDW110v Data Model Fundamentals|2023 LATEST UPDATE|GUARANTEED SUCCESS

Caboodle Console ... Data Warehouse ... ETL ... Package ... SSIS ... Staging Database ... Star Schema ... Surrogate Key ... How do you Identify key characteristics of the dimensional data model? ... How do you Identify the benefits of the dimensional data model? ... How do you Identify reporting needs that best fit Caboodle? ... Differentiate between Clarity and Caboodle. ... Explain how data flows into Caboodle. ... Explain the benefits of the dimensional data model. ... Explain the difference between a normalized data model and a dimensional data model. ... Explain where Caboodle fits among Epic's reporting tools. ... Define Business Key ... Define Data Lineage ... Define Dictionary ... Define Dimension Table ... Define Durable Key ... Define Fact Table ... Define ID ... Define IdType ... How do you Navigate the Caboodle Console? ... How do you look up the data lineage of a table? ... How do you look up the data lineage of a column? ... How do you identify Epic data in Caboodle? ... How do you identify non-Epic data in Caboodle? ... Explain who uses the Caboodle Console. ... Explain how data is loaded into Caboodle. ... T/F: All changes to the data extracted to PatientDim generate new rows. False Although PatientDim is a type 2, only certain columns in it are type 2. Changes to the data stored in type 1 columns do not create new rows. Rather, the existing value is overwritten across existing rows for a given entity. T/F: In the FullAccess schema, joining to a type 2 table always returns the current values for the entities in the views. False The FullAccess views contain the historical information, just like the dbo tables do, unless you join to the _Current views. Type 1 Data ... Type 2 Data ... "_Current" View ... StartDate Column ... EndDate Column ... Durable Key ... How do you identify whether changing data will trigger an update to an existing row or create a new row? ... How do you successfully report with current and/or historical data? ... How do you use durable keys to find the information about an entity and understand its history? ... How do you identify from looking at the data in a table whether the table is type 1 or type 2? ... Explain foreign key references from Type 2 tables. ... Explain the difference between Type 1 and Type 2 data. ... Explain the difference between Type 1 and Type 2 tables. ... Suppose you are creating a report that displays the name of each patient's current PCP. If a particular patient's PCP has not been extracted to ProviderDim, how will their name appear in the report? Since the patient's data references their PCP, an inferred row would have been created for their PCP in ProviderDim. All strings in inferred rows (except IdType) are "*Unknown," so that is what would appear for the provider's name. T/F: Inferred rows can only exist for a limited time. False An inferred row will remain until data for its corresponding entity is extracted. If a foreign key is null in Clarity, what will appear in the corresponding column in Caboodle? If the foreign key was expected to contain data, then a -1 will appear in Caboodle to represent an unspecified value. If the foreign key was not expected to contain data, then a -2 will appear in Caboodle to represent a value that is not applicable. Define Deleted Rows ... Define Not Applicable Rows ... Define Unspecified Rows ...