Thus, all answers for the below mentioned questions are correct (for your learning). NOTE: The purpose of this post is to povide a learning for those preparing for SAS interview or global certification. Select name, Avg(marks) from class group by name Select name, sum(count) from hosp2 group by name
The dimension are structured to minimize update anomalies and to address single themes.Dataset below shows the hospital visit by patients during the entire year (2012)įind out how many times each patient has visited the hospital in using proc freq, proc report, proc sql Snow flake schema is defined in which a single fact table is connected to multiple dimension tables. Each time the address or income changes for a customer, a new row could be created for that customer in the dimensional table and old row could be retained. For example, a dimension table named customers might have columns for customer id, home address and income. This is the technique for tracking changes to dimensional table values in order to analyze trends. It is the access by selected business users to raw (untransformed) data loads. This process exists to manage updates of business rules to maintain a level of consistency. It is the robust, reliable, repeatable and controlled process both at point of input and through subsequent downstream control checks. The data staging area is everything between the operational source systems and the data presentation area. Staging area of the data warehouse is both the storage area and set of process commonly referred as extract transformation load.
Header Column – Lists the name of the columns.ĥ) What are the benefits of data integration?įollowing are the benefits of data integration:.Data Field Column – It contains the pivot data along with pivot columns values.Pivot Set – A group of pivot columns, unique data field and header column.Non-Pivot column – The columns that need to appear in the target.Pivot Sequence Column – Data Integrator increments a sequence number for every row created from a pivot column.More than one pivot column can be set as per the need of application’s data integration.Data Integrator produces a row in the output data set for every value in the designated pivot column.One or more columns in a primary key cannot contain null values.Ĥ) Explain about Pivot – Columns to Rows?
While on the other hand table can have only one primary key. A table can have one or more unique keys. Unique key is one or more columns that can be used to uniquely identify a row in a table. It is a metadata object which determines how to extract data, transform data and load data into data stores.ģ) What is the difference between unique key and primary key?
ITIL Managing Professional Masters Program.ITIL Expert Capability Stream Masters Program.