Interview Questions.

Q1. What Are The Prime Responsibilities Of Data Integration Administrator?

Scheduling and executing the batch jobs.

Configuring, beginning and stopping the real-time services

Adapters configuration and handling them.

Repository usage, Job Server configuration.

Access Server configuration.

Batch task publishing.

Real-time offerings publishing through internet offerings.

Q2. What Is The Use Of Sas Management Console?

SAS management console utility offers a single consumer interface for appearing SAS administrative duties.

Q3. Describe About Physical Data Integration?

Physical Data Integration is all approximately developing new machine that replicates records from the supply structures. This system is performed to manipulate the facts unbiased of the authentic device. Data Warehouse is the example of Physical Data Integration. The benefits of PDI encompass records model control, aggregate of facts from various assets, like mainframes, flat documents, databases.

Q4. Explain The Difference Between Alternate Key, Business Key, Foreign Key , Generated Key , Primary Key, Retained Key And Surrogate Key ?

Alternate key's time period also called specific key.

Business key is one or greater columns in a measurement table that comprise the primary key in a source table in an operational system.

Foreign key's one or more columns which are related to a number one key or particular key in another desk. A desk will have one or greater overseas keys. A overseas key is established upon its related number one or specific key. In other phrases, a foreign key cannot exist without that number one or precise key.

Generated keys is used to enforce surrogate keys and retained keys, one or greater columns that are used to uniquely discover a row in a table. A desk will have only one number one key. One or extra columns in a primary key can not comprise null values. Retained key's a numeric column in a measurement desk this is the number one key of that desk.

Surrogate key is a column which includes particular integer values which can be generated sequentially whilst rows are delivered and updated. In the related truth table, the surrogate key's covered as a foreign key to be able to connect with precise dimensions.

Q5. What Do You Mean By Data Staging Area?

Staging location of the information warehouse is both the garage region and set of process typically referred as extract transformation load. The information staging region is everything among the operational supply structures and the facts presentation area.

Q6. Explain About Various Caches Available In Data Integrator?

NO_CACHE – It is used for not caching values.

PRE_LOAD_CACHE – Result column preloads and compares the column into the reminiscence, prior to executing the lookup.

PRE_LOAD_CACHE is used when the desk can exactly fit within the memory space.

DEMAND_LOAD_CACHE – Result column loads and compares the column into the reminiscence while a characteristic performs the execution.

DEMAND_LOAD_CACHE is appropriate at the same time as looking up the exceptionally repetitive values with small subset of data.

Q7. What Is Change Analysis In Sas Di?

Change analysis is the system of comparing one set of metadata to some other set of metadata and figuring out the variations between the two sets of metadata.

Q8. Is Data Integration And Etl Programming Is Same?

No, Data Integration and ETL programming are exceptional.

Passing of statistics to special systems from other structures is known as data integration.

It may integrate records within the equal application.

ETL, on the other hand, is to extract the facts from specific resources.

The number one ETL device task is to convert the facts and loads into other gadgets or tables.

Q9. Explain About Data Integrator Metadata Reports?

Browser-primarily based analysis and reporting capabilities are supplied by way of Metadata reviews.

The DI Metadata Reports are generated on metadata that friends with Data Integration jobs.

Other BO applications those are associated with Data Integration.

Three modules are provided by Metadata Reports. They are:

Operational Dashboards.

Auto Documentation.

Impact and Lineage evaluation.

Q10. What Is Data Integration?

The method of mixing facts from one-of-a-kind assets.

The combined statistics is furnished to the customers with unified view.

Information from distinctive enterprise domains are incorporated – known as Enterprise Information Integration.

Useful for merging information from specific technologies among enterprises.

Q11. Describe The Interaction Table In Sas Di?

Table that describes the relationships between  or extra tables. For instance, an intersection desk should describe the various-to-many relationships among a table of users and a table of corporations.

Q12. What Is Sas Application Server, Database Server, Sas Olap Server And Sas Metadata Server?

SAS utility server provides SAS services to a patron. On the other hand database server presents relational database provider to a consumer. Oracle, DB2, and Teradata are examples of relational databases.  SAS OLAP server offers get right of entry to to multidimensional information. SAS metadata server gives metadata control services to at least one or more client application.

Q13. What Is Data Access?

It is the access via selected business customers to uncooked (untransformed) information masses.

Q14. Why Is Sas Data Integration Studio Important?

Companies are figuring out that a good way to be triumphant they want an included view of their facts and SAS Data Integration Studio is the single tool that gives the power, reliability and agility needed to reply to new facts integration challenges. Regardless of the challenge, SAS Data Integration Studio users can reply with pace and performance, lowering the overall price of information integration.

Q15. What Is Star Schema?

Star schema is defined as database in which unmarried reality table is hooked up to a couple of size tables. This is represented in a celeb schema.

Q16. What Are The Benefits Of Data Integration?

Following are the blessings of records integration:

Makes reporting, monitoring, setting consumer data throughout the employer flexible and convenient.

Data utilization is efficient.

Cost Effective.

Risk adjusted profitability control as it lets in correct facts extraction.

Allows well timed and reliable reporting, as records exceptional is the prime technology for enterprise demanding situations.

Q17. What Is Data Governance?

It is the robust, dependable, repeatable and managed technique each at factor of input and thru subsequent downstream manipulate tests. This system exists to control updates of business regulations to preserve a stage of consistency.

Q18. What Is Operational Data And Operational System?

Operational statistics is used as source statistics for a records warehouse. While operational device is one or extra packages that provide source information for a records warehouse.

Q19. For Whom Is Sas Data Integration Studio Designed?

SAS Data Integration Studio empowers records integration managers and architects to work more successfully, manage exchange correctly and supply incredible effects quicker.

Our layout of route tutorials and interview questions is practical and informative. At TekSlate, we provide resources to help you learn numerous IT guides. We avail each written material and demo video tutorials. For in-depth know-how and sensible experience explore Online SAS DI Training.

Q20. What Is Hierarchy Flattening?

Construction of figure/child relationships hierarchy is referred to as Hierarchy Flattening.

A description of hierarchy in the vertical or horizontal format is produced.

The hierarchy pattern includes Parent column, Child Column, Parent Attributes and Child Attributes.

Hierarchy Flattening allows to apprehend the fundamental hierarchy of BI in a lucid manner.

As the knocking down is achieved in horizontal or vertical layout, the sub factors are effortlessly identified.

Q21. What Is Transformation In Sas Data Integration?

It is a metadata object which determines how to extract information, transform information and load records into statistics shops.

Q22. Describe About Metadata Object?

It is a fixed of attributes that describe a table, a server, a user and another aid on a community.

Q23. What Is Slowly Changing Dimension?

This is the technique for monitoring adjustments to dimensional desk values so as to investigate trends. For example, a measurement table named clients might have columns for consumer identity, home address and earnings. Each time the cope with or earnings changes for a client, a brand new row may be created for that purchaser within the dimensional table and vintage row will be retained.

Q24. Name The Scheduler For Scheduling Job And Explain The Scheduler?

The scheduler used for scheduling task is manipulate m while CONTROL-m also consumer to view method drift and dependencies if you want to optimize commercial enterprise strategies effortlessly and successfully, even in a statistics center that consists of a couple of platform types (for instance, Unix, Microsoft Windows, and MVS)

Q25. What Is Snowflake Schema?

Snowflake schema is described wherein a single fact table is connected to more than one dimension tables. The measurement are dependent to minimize replace anomalies and to address unmarried subject matters.

Q26. Name Some Data Transformation Used In Sas Di?

Types of the statistics transformation are append, follow lookup standardization, create match code transformation, facts transfer, records validation, extract, fact table research, key powerful records transformation, research, SAS rank, SAS sort, SAS splitter, SCD kind 2 loader, SQL be part of, standardize transformation, Surrogate key generator , Transpose transformation, User written code transformation.

Q27. Describe How To Adjust The Performance Of Data Integrator?

Following are the methods to perform this:

Using array fetch size.

Ordering the joins.

Extracted data minimizing.

Locale conversion minimization.

Setting goal-based totally alternatives to optimize the performance.

Improving throughput.

Data type conversion minimization.

Q28. What Is The Difference Between Unique Key And Primary Key?

Unique key's one or extra columns that may be used to uniquely pick out a row in a desk. A table can have one or extra unique keys. Unique keys can incorporate null values. While alternatively table can have handiest one number one key. One or more columns in a primary key can not comprise null values.

Q29. What Is Change Analysis In Sas Di ?

Change evaluation is the method of evaluating one set of metadata to every other set of metadata and figuring out the differences among the 2 sets of metadata.