Explore topic-wise InterviewSolutions in .

SAS Data Integration Studio empowers data integration managers and designers to work more efficiently, manage change effectively and deliver high-quality results faster.

Our design of COURSE tutorials and interview questions is PRACTICAL and informative. At TekSlate, we offer RESOURCES to HELP you learn various IT courses. We avail both written material and demo video tutorials. For in-depth knowledge and practical experience explore ONLINE SAS DI Training.

SAS Data Integration Studio empowers data integration managers and designers to work more efficiently, manage change effectively and deliver high-quality results faster.

Our design of course tutorials and interview questions is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online SAS DI Training.

Companies are REALIZING that in order to succeed they NEED an integrated view of their data and SAS Data Integration Studio is the single tool that provides the flexibility, reliability and agility needed to respond to new data integration CHALLENGES. Regardless of the project, SAS Data Integration Studio users can respond with SPEED and efficiency, reducing the overall COST of data integration.

Companies are realizing that in order to succeed they need an integrated view of their data and SAS Data Integration Studio is the single tool that provides the flexibility, reliability and agility needed to respond to new data integration challenges. Regardless of the project, SAS Data Integration Studio users can respond with speed and efficiency, reducing the overall cost of data integration.

• ALTERNATE key is term also known as unique key.
• Business key is one or more columns in a dimension table that comprise the primary key in a SOURCE table in an operational system.
• Foreign key is one or more columns that are associated with a primary key or unique key in another table. A table can have one or more foreign keys. A foreign key is dependent upon its associated primary or unique key. In other words, a foreign key cannot exist without that primary or unique key.
• Generated keys is used to implement surrogate keys and retained keys, one or more columns that are used to uniquely identify a ROW in a table. A table can have only one primary key. One or more columns in a primary key cannot contain null values. Retained key is a numeric column in a dimension table that is the primary key of that table.
• Surrogate key is a column which contains unique integer values that are generated sequentially when rows are added and updated. In the associated fact table, the surrogate key is included as a foreign key in order to connect to specific dimensions.

Table that describes the relationships between two or more TABLES. For EXAMPLE, an intersection table COULD describe the many-to-many relationships between a table of users and a table of groups.

Table that describes the relationships between two or more tables. For example, an intersection table could describe the many-to-many relationships between a table of users and a table of groups.

Change analysis is the process of COMPARING one set of metadata to another set of metadata and identifying the DIFFERENCES between the TWO SETS of metadata.

Change analysis is the process of comparing one set of metadata to another set of metadata and identifying the differences between the two sets of metadata.

The SCHEDULER used for scheduling job is CONTROL m while CONTROL-m also user to VIEW process flow and dependencies so that they can OPTIMIZE business processes easily and efficiently, EVEN in a data center that includes multiple platform types (for example, Unix, Microsoft Windows, and MVS)

The scheduler used for scheduling job is control m while CONTROL-m also user to view process flow and dependencies so that they can optimize business processes easily and efficiently, even in a data center that includes multiple platform types (for example, Unix, Microsoft Windows, and MVS)

It is a set of ATTRIBUTES that describe a table, a SERVER, a USER and another resource on a network.

It is a set of attributes that describe a table, a server, a user and another resource on a network.

TYPES of the data transformation are append, apply lookup standardization, CREATE match code transformation, data transfer, data validation, extract, FACT table lookup, key effective data transformation, lookup, SAS RANK, SAS sort, SAS splitter, SCD TYPE 2 loader, SQL join, standardize transformation, Surrogate key generator , Transpose transformation, User written code transformation.

Types of the data transformation are append, apply lookup standardization, create match code transformation, data transfer, data validation, extract, fact table lookup, key effective data transformation, lookup, SAS rank, SAS sort, SAS splitter, SCD type 2 loader, SQL join, standardize transformation, Surrogate key generator , Transpose transformation, User written code transformation.

SAS management console application provides a SINGLE USER INTERFACE for performing SAS ADMINISTRATIVE tasks.

SAS management console application provides a single user interface for performing SAS administrative tasks.

Operational data is used as source data for a data warehouse. While operational SYSTEM is ONE or more PROGRAMS that PROVIDE source data for a data warehouse.

Operational data is used as source data for a data warehouse. While operational system is one or more programs that provide source data for a data warehouse.

SAS application server provides SAS services to a client. On the other HAND DATABASE server provides relational database service to a client. ORACLE, DB2, and Teradata are examples of relational databases. SAS OLAP server provides access to multidimensional data. SAS metadata server provides metadata MANAGEMENT services to one or more client application.

SAS application server provides SAS services to a client. On the other hand database server provides relational database service to a client. Oracle, DB2, and Teradata are examples of relational databases. SAS OLAP server provides access to multidimensional data. SAS metadata server provides metadata management services to one or more client application.

Snowflake schema is defined in which a SINGLE fact table is connected to multiple DIMENSION TABLES. The dimension are STRUCTURED to minimize update anomalies and to address single THEMES.

Snowflake schema is defined in which a single fact table is connected to multiple dimension tables. The dimension are structured to minimize update anomalies and to address single themes.

It is the access by selected BUSINESS users to RAW (untransformed) DATA LOADS.

It is the access by selected business users to raw (untransformed) data loads.

It is the robust, reliable, repeatable and CONTROLLED PROCESS both at point of INPUT and through subsequent downstream control checks. 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. This process exists to manage updates of business rules to maintain a level of consistency.

Staging area of the DATA warehouse is both the storage area and set of PROCESS commonly referred as EXTRACT TRANSFORMATION load. 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. The data staging area is everything between the operational source systems and the data presentation area.

• DATA Integrator produces a ROW in the output data set for every VALUE in the designated pivot column.
• More than one pivot column can be set as per the need of application’s data integration.

Pivot Sequence Column – Data Integrator increments a sequence NUMBER for every row created from a pivot column.

Non-Pivot column – The columns that need to appear in the target.

Pivot Set – A group of pivot columns, unique data field and header column.

Data Field Column – It contains the pivot data along with pivot columns values.

Header Column – Lists the name of the columns.

Pivot Sequence Column – Data Integrator increments a sequence number for every row created from a pivot column.

Non-Pivot column – The columns that need to appear in the target.

Pivot Set – A group of pivot columns, unique data field and header column.

Data Field Column – It contains the pivot data along with pivot columns values.

Header Column – Lists the name of the columns.

Unique key is one or more COLUMNS that can be used to UNIQUELY IDENTIFY a ROW in a table. A table can have one or more unique keys. Unique keys can contain null values. While on the other hand table can have only one primary key. One or more columns in a primary key cannot contain null values.

Unique key is one or more columns that can be used to uniquely identify a row in a table. A table can have one or more unique keys. Unique keys can contain null values. While on the other hand table can have only one primary key. One or more columns in a primary key cannot contain null values.

CHANGE analysis is the PROCESS of comparing one set of metadata to another set of metadata and IDENTIFYING the differences between the TWO SETS of metadata.

Change analysis is the process of comparing one set of metadata to another set of metadata and identifying the differences between the two sets of metadata.

It is a METADATA object which DETERMINES how to extract data, TRANSFORM data and LOAD data into data stores.

It is a metadata object which determines how to extract data, transform data and load data into data stores.