SSIS/SSAS/SSRS/SQL
Server /Data Warehouse Interview Questions and answers
SSIS
1. What is a
package?
a).a discrete executable unit of work composed of a collection of control flow and other objects, including data sources, transformations, process sequence, and rules, errors and event handling, and data destinations.
2. What is a workflow in SSIS?
a).`a workflow is a set of instructions on how to execute Tasks.
(It is a set of instructions on how to execute Tasks such as sessions, emails and shell commands. a workflow is created form work flow mgr.)
3. What is the Difference between control flow Items and data flow Items?
a).the control flow is the highest level control process. It allows you to manage the run-time process the run time process activities of data flow and other processes within a package.
When we want to extract, transform and load data within a package. You add an SSIS dataflow Task to the package control flow.
4. What are the main components of SSIS (project-architecture)?
A).SSIS architecture has 4 main components
1.SSIS service
2.SSIS runtime engine & runtime executables
3.SSIS dataflow engine & dataflow components
4.SSIS clients’
5.different components in SSIS package?
1. Control flow
2.data flow
3.event handler
4.package explorer
Containers: provide structure and scope to your package
Types of containers:
i. Task host container: the Taskhost container services a single Task.
ii. Sequence container: It can handle the flow of subset of a package and can help you drive a package into smaller more manageable process.
Uses:-
a).a discrete executable unit of work composed of a collection of control flow and other objects, including data sources, transformations, process sequence, and rules, errors and event handling, and data destinations.
2. What is a workflow in SSIS?
a).`a workflow is a set of instructions on how to execute Tasks.
(It is a set of instructions on how to execute Tasks such as sessions, emails and shell commands. a workflow is created form work flow mgr.)
3. What is the Difference between control flow Items and data flow Items?
a).the control flow is the highest level control process. It allows you to manage the run-time process the run time process activities of data flow and other processes within a package.
When we want to extract, transform and load data within a package. You add an SSIS dataflow Task to the package control flow.
4. What are the main components of SSIS (project-architecture)?
A).SSIS architecture has 4 main components
1.SSIS service
2.SSIS runtime engine & runtime executables
3.SSIS dataflow engine & dataflow components
4.SSIS clients’
5.different components in SSIS package?
1. Control flow
2.data flow
3.event handler
4.package explorer
Containers: provide structure and scope to your package
Types of containers:
i. Task host container: the Taskhost container services a single Task.
ii. Sequence container: It can handle the flow of subset of a package and can help you drive a package into smaller more manageable process.
Uses:-
1. Grouping Tasks so that you can disable a part of the package that no
longer needed.
2. Narrowing the scope of the variable to a container.
3. Managing the property of multiple Tasks in one step by setting the properties of the container.
iii. For loop container: evaluates an expression and repeats Its workflow until the expression evaluates to false.
iv. For each loop container: defines a control flow repeatedly by using an enumerator.
For each loop container repeats the control flow for each member of a specified enumerator.
Tasks: It provides the functionality to your package.
2. Narrowing the scope of the variable to a container.
3. Managing the property of multiple Tasks in one step by setting the properties of the container.
iii. For loop container: evaluates an expression and repeats Its workflow until the expression evaluates to false.
iv. For each loop container: defines a control flow repeatedly by using an enumerator.
For each loop container repeats the control flow for each member of a specified enumerator.
Tasks: It provides the functionality to your package.
Ø It is a individual unit of work.
Event handler: It responds to raised events in your package.
Precedence constraints: It provides ordinal relationship b/w various Items in your package.
Event handler: It responds to raised events in your package.
Precedence constraints: It provides ordinal relationship b/w various Items in your package.
6. How to deploy the package?
To deploy the package first we need to configure some properties.
To deploy the package first we need to configure some properties.
Ø Go to project tab->package properties->we get a window, configure
deployment Utility as "True"
Ø Specify the path as "bin/deployment"
7. Connection manager:
a).It is a bridge b/w package object and physical data. It provides logical representation of a connection at design time the properties of the connection mgr describes the physical connection that integration services creates when the package is run.
8. Tell the Utility to execute (run) the package?
a) In BIDS a package that can be executed in debug mode by using the debug menu or toolbar or from solution explorer.
In production, the package can be executed from the command line or from Microsoft windows Utility or It can be scheduled for automated execution by using the SQL server agent.
i). Go to->debug menu and select the start debugging button
ii).press F5 key
iii).right click the package and choose execute package.
iv).command prompts utilities
a).It is a bridge b/w package object and physical data. It provides logical representation of a connection at design time the properties of the connection mgr describes the physical connection that integration services creates when the package is run.
8. Tell the Utility to execute (run) the package?
a) In BIDS a package that can be executed in debug mode by using the debug menu or toolbar or from solution explorer.
In production, the package can be executed from the command line or from Microsoft windows Utility or It can be scheduled for automated execution by using the SQL server agent.
i). Go to->debug menu and select the start debugging button
ii).press F5 key
iii).right click the package and choose execute package.
iv).command prompts utilities
a).DTExecUI
1. To open command prompt->run->type dtexecui->press enter
2. The execute package Utility dialog box opens.
3. in that click execute to run the package.
Wait until the package has executed successfully.
b).DTExec Utility
1.open the command prompt window.
2. Command prompt window->type dtexec /followed by the DTS, SQL, or file option and the package path, including package name.
3. If the package encryption level is encrypting sensitive with password or encrypt all with password, use the decrypt option to provide the password.
If no password is included, dtexec will prompt you for the password.
4. Optionally, provide additional command-line options
5. Press enter.
6. Optionally, view logging and reporting information before closing the command prompt window.
The execute package Utility dialog box opens.
7. In the execute package Utility dialog box, click execute package.
Wait until the package has executed successfully.
v).using SQL server mgmt studio to execute package
1. In SSMS right click a package, and then click run package.
Execute package Utility opens.
2. Execute the package as described previously.
9. How can u design SCD in SSIS?
a) Def:-SCD explains how to capture the changes over the period of time.
This is also known as change data capture.
type1: It keeps the most recent values in the target. It does not maintain the history.
type2: It keeps the full history in the target database. For every update in the source a new record is inserted in the target.
type3: It keeps current & previous information in the target.
10. How can u handle the errors through the help of logging in SSIS?
a) To create an on error event handler to which you add the log error execute SQL Task.
11. What is a log file and how to send log file to mgr?
a) It is especially useful when the package has been deployed to the production environment, and you cannot use BIDS and VSA to debug the package.
SSIS enables you to implement logging code through the Dts. Log method.
When the Dts. Log method is called in the script, the SSIS engine will route the message to the log providers that are configured in the containing package.
12. What is environment variable in SSIS?
a) An environment variable configuration sets a package property equal to the value in an environment variable.
Environmental configurations are useful for configuring properties that are dependent on the computer that is executing the package.
13. about multiple configurations?
a) It means including the xml configuration, environment variable, registry entry, parent package variable, SQL Server table, and direct and indirect configuration types.
14. How to provide security to packages?
a) In two ways
1. Package encryption
2. Password protection.
15. as per error handling in T/R, which one handle the better performance? Like fail component, redirect row or ignore failure?
a) Redirect row provides better performance for error handling.
16. Staging area??
a) It is a temporary data storage location. Where various data T/R activities take place.
a) To create an on error event handler to which you add the log error execute SQL Task.
11. What is a log file and how to send log file to mgr?
a) It is especially useful when the package has been deployed to the production environment, and you cannot use BIDS and VSA to debug the package.
SSIS enables you to implement logging code through the Dts. Log method.
When the Dts. Log method is called in the script, the SSIS engine will route the message to the log providers that are configured in the containing package.
12. What is environment variable in SSIS?
a) An environment variable configuration sets a package property equal to the value in an environment variable.
Environmental configurations are useful for configuring properties that are dependent on the computer that is executing the package.
13. about multiple configurations?
a) It means including the xml configuration, environment variable, registry entry, parent package variable, SQL Server table, and direct and indirect configuration types.
14. How to provide security to packages?
a) In two ways
1. Package encryption
2. Password protection.
15. as per error handling in T/R, which one handle the better performance? Like fail component, redirect row or ignore failure?
a) Redirect row provides better performance for error handling.
16. Staging area??
a) It is a temporary data storage location. Where various data T/R activities take place.
Staging
area is a kitchen of data warehouse.
17. Task??
a) An individual unit of work.
17. Task??
a) An individual unit of work.
Types:-
1.
Active x script Task
2. Analysis services execute DDL Task *
3. Analysis services processing Task *
4. Bulk insert Task *
5. Data flow Task *
6. Data mining query Task
7. Execute Dts 2000 package Task
8. Execute package Task *
9. Execute process Task
10. Execute SQL Task *
11. File system Task *
12. Ftp Task
13. Message queue Task
14. Script Task *
15. Send mail Task *
16. Web service Task
17. Wmi data reader Task
18. Wmi event Task
19. Xml Task
18. Event handler & logging?
Even handler is the mechanism to raise a event based on specific scenario. For example if there is any failure in data load it will notify thru email or entry in error table etc.
2. Analysis services execute DDL Task *
3. Analysis services processing Task *
4. Bulk insert Task *
5. Data flow Task *
6. Data mining query Task
7. Execute Dts 2000 package Task
8. Execute package Task *
9. Execute process Task
10. Execute SQL Task *
11. File system Task *
12. Ftp Task
13. Message queue Task
14. Script Task *
15. Send mail Task *
16. Web service Task
17. Wmi data reader Task
18. Wmi event Task
19. Xml Task
18. Event handler & logging?
Even handler is the mechanism to raise a event based on specific scenario. For example if there is any failure in data load it will notify thru email or entry in error table etc.
Logging
can be done based on event, in SSIS there are 12 events that can be logged at Task
or package level. You can enable partial logging for one Task and enable much
more detailed logging for billing Tasks.
Example:-
Example:-
On error; On post validate; On progress; On warning
In SSIS different type of logging mechanism are there:
In SSIS different type of logging mechanism are there:
SQL
profiler
Text files
SQL server
Window event log
Xml file
19. Import & export wizard?
a) Easiest method to move data from sources like oracle, db2, SQL server.
Right click on database name->go to Task->import and export wizard
Select the source
Select the destination
Query copy of tables
Execute
Finish
20.what solution explorer?
Once you creating project with specific project name then if you want to add
data source/-data source views/packages/ miscellaneous; then this window will help to organize different files under one structure.
21. Precedence constraints?
a) Constraints that link executable, container, and Tasks within the package control flow and specify condition that determine the sequence
and conditions for determine whether executable run.
22. Data pipeline?
a) The memory based, multithreaded, buffered t/r process flow data through an SSIS data flow Task during package execution.
23. TRANSFORMATIONS??
It is an object that generates, modifies, or passes data.
1. AGGEGATE T/R:-It applies an aggregate function to grouped records and produces new output records from aggregated results.
2. AUDIT T/R:-the t/r adds the value of a system variable, such as machine name or execution instance GUID to a new output column.
3. CHARACTER MAP T/R:-this t/r makes string data changes such as changing data from lower case to upper case.
4. CONDITIONAL SPLIT:-It separate input rows into separate output data pipelines based on the Boolean expressions configured for each output.
5. COPY COLUMN:-add a copy of column to the t/r output we can later transform the copy keeping the original for auditing personal
6.DATA CONVERSION:-converts a columns data type to another data type.
7. DATA MINING QUERY:-perform a data mining query against analysis services.
8. DERIVED COLUMN:-create a new derive column calculated from expression.
9. EXPORT COLUMN:-It allows you to export a column from the data flow to a file.
10. FUZZY GROUPING:-perform data cleansing by finding rows that are likely duplicates.
11. FUZZY LOOKUP:-matches and standardizes data based on fuzzy logic.
Ex:-transform the name jon to john
12.IMPORT COLUMN:-reads the data from a file & adds It into a dataflow.
13. LOOKUP:-perform the lookup of data to be used later in a transform.
Ex:-t/T to lookup a city based on zip code.
1. Getting a related value from a table using a key column value
2. Update slowly changing dimension table
3.to check whether records already exist in the table.
14. MERGE:-merges two sorted data sets into a single data set into a single data flow.
15. MERGE JOIN:-merges two data sets into a single dataset using a join junction.
16. MULTI CAST:-sends a copy of two data to an additional path in the workflow.
17. ROW COUNT:-stores the rows count from the data flow into a variable.
18. ROW SAMPLING:-captures the sample of data from the dataflow by using a row count of the total rows in dataflow.
19. ROW SAMPLING:-captures the sample of the data from the data flow by using a row count of the total rows in data flow.
20. UNION ALL:-merge multiple data sets into a single dataset.
21. PIVOT:-converts rows into columns
22.UNPIVOT:-converts columns into rows
24. Batch?
a) A batch is defined as group of sessions. Those are 2 types.
1. Parallel batch processing
2. Sequential batch processing
to execute a SSIS package we will use "execute package utility"
To deploy a SSIS package we will use "package deployment Utility”
SSRS:--
1. What are the main components of reporting services?
a) Report designer, report server, report manager, report user.
2. Where can u publish the report?
a) By using report designer or publish reports on report server.
3. What are the necessity things for creating matrix report?
a) Page, column, row, details
4. For generating reports which is used like RDBMS OR CUBE?
a) Depends on data; report can be developed using different source like database tables/cube/text files etc.
5. What is .rdl file?
a) .rdl is a Report Definition Language. Every report saves with .rdl extension.
Text files
SQL server
Window event log
Xml file
19. Import & export wizard?
a) Easiest method to move data from sources like oracle, db2, SQL server.
Right click on database name->go to Task->import and export wizard
Select the source
Select the destination
Query copy of tables
Execute
Finish
20.what solution explorer?
Once you creating project with specific project name then if you want to add
data source/-data source views/packages/ miscellaneous; then this window will help to organize different files under one structure.
21. Precedence constraints?
a) Constraints that link executable, container, and Tasks within the package control flow and specify condition that determine the sequence
and conditions for determine whether executable run.
22. Data pipeline?
a) The memory based, multithreaded, buffered t/r process flow data through an SSIS data flow Task during package execution.
23. TRANSFORMATIONS??
It is an object that generates, modifies, or passes data.
1. AGGEGATE T/R:-It applies an aggregate function to grouped records and produces new output records from aggregated results.
2. AUDIT T/R:-the t/r adds the value of a system variable, such as machine name or execution instance GUID to a new output column.
3. CHARACTER MAP T/R:-this t/r makes string data changes such as changing data from lower case to upper case.
4. CONDITIONAL SPLIT:-It separate input rows into separate output data pipelines based on the Boolean expressions configured for each output.
5. COPY COLUMN:-add a copy of column to the t/r output we can later transform the copy keeping the original for auditing personal
6.DATA CONVERSION:-converts a columns data type to another data type.
7. DATA MINING QUERY:-perform a data mining query against analysis services.
8. DERIVED COLUMN:-create a new derive column calculated from expression.
9. EXPORT COLUMN:-It allows you to export a column from the data flow to a file.
10. FUZZY GROUPING:-perform data cleansing by finding rows that are likely duplicates.
11. FUZZY LOOKUP:-matches and standardizes data based on fuzzy logic.
Ex:-transform the name jon to john
12.IMPORT COLUMN:-reads the data from a file & adds It into a dataflow.
13. LOOKUP:-perform the lookup of data to be used later in a transform.
Ex:-t/T to lookup a city based on zip code.
1. Getting a related value from a table using a key column value
2. Update slowly changing dimension table
3.to check whether records already exist in the table.
14. MERGE:-merges two sorted data sets into a single data set into a single data flow.
15. MERGE JOIN:-merges two data sets into a single dataset using a join junction.
16. MULTI CAST:-sends a copy of two data to an additional path in the workflow.
17. ROW COUNT:-stores the rows count from the data flow into a variable.
18. ROW SAMPLING:-captures the sample of data from the dataflow by using a row count of the total rows in dataflow.
19. ROW SAMPLING:-captures the sample of the data from the data flow by using a row count of the total rows in data flow.
20. UNION ALL:-merge multiple data sets into a single dataset.
21. PIVOT:-converts rows into columns
22.UNPIVOT:-converts columns into rows
24. Batch?
a) A batch is defined as group of sessions. Those are 2 types.
1. Parallel batch processing
2. Sequential batch processing
to execute a SSIS package we will use "execute package utility"
To deploy a SSIS package we will use "package deployment Utility”
SSRS:--
1. What are the main components of reporting services?
a) Report designer, report server, report manager, report user.
2. Where can u publish the report?
a) By using report designer or publish reports on report server.
3. What are the necessity things for creating matrix report?
a) Page, column, row, details
4. For generating reports which is used like RDBMS OR CUBE?
a) Depends on data; report can be developed using different source like database tables/cube/text files etc.
5. What is .rdl file?
a) .rdl is a Report Definition Language. Every report saves with .rdl extension.
SSAS:-
1. What are the fixed measure and calculated measure?
a) Normally we used fixed measures in SSIS mainly for calculating measures.
Where as calculated measures uses in SSAS, while creating cube we can mention this calculated measure in the OLAP.
2. What are measures?
a) Measures are numeric data based on columns in a fact table.
3. What are cubes?
a) Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis.
4. What are virtual cubes?
These are combination of one or more real cubes and require no disk space to store them. They store only definition and not the data.
DATAWARE HOUSE CONCEPTS:-
1. Difference b/w OLTP AND OLAP?
1. What are the fixed measure and calculated measure?
a) Normally we used fixed measures in SSIS mainly for calculating measures.
Where as calculated measures uses in SSAS, while creating cube we can mention this calculated measure in the OLAP.
2. What are measures?
a) Measures are numeric data based on columns in a fact table.
3. What are cubes?
a) Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis.
4. What are virtual cubes?
These are combination of one or more real cubes and require no disk space to store them. They store only definition and not the data.
DATAWARE HOUSE CONCEPTS:-
1. Difference b/w OLTP AND OLAP?
OLTP
|
OLAP
|
1.transactional processing
|
1.query processing
|
2.time sensitive
|
2.history oriented
|
3. Operator & clerks view
|
3.Managers, CEOs, PM’s views
|
4. Organized by transaction
(Order, input, inventory) |
4.organized
by subjects
(product, customer) |
5.relatively smaller DB
|
5.large DB size
|
6.volatile data
|
6.non-volatile
|
7.stores all data
|
7.stores relevant data
|
8. Not flexible
|
8.flexible
|
2. Difference b/w star schema and snowflake?
STAR Schema
|
Snowflake Schema
|
1 centrally located fact table surrounded by de
normalize dimension table
|
1 Centraly located fact table surrounded by the
normalized dimension table
|
2 All dimensions will be linked directly with
fact table
|
2 All dim link wIth each other (or)
1-N relationship with other table |
3 It is easy to understand the design
|
3 It is difficult to understand
|
4 We can easily retrieve data parsing the query
against the Fact and Dim table
|
4 It is difficult to retrieve the data while
|
5 Increase the query performance because it
involve less joins
|
5 more joins
|
What are fact tables?
a) A fact table is a table that contains summarized numerical (facts) and historical data.
This fact table has a foreign key-primary key relation with a dimension table. The fact table maintains the information in 3rd normal form.
3. Types of facts?
a)
1. Additive:-able to add the facts along with all the dimensions
-discrete numerical measures.
-Ex:-retail sales in $
2. Semi additive:-snapshot taken at a point in time
- Measure of intensity
-not additive along time dimensions
ex:-account balance, inventory balance
3.non-addItive:-numerical measures that can't be added across any dimensions.
Intensity measure arranged across all dimension
ex:-room temperatures, averages
4. Data warehouse?
a) A data ware house is a collection of data marts representing historical data from Difference operational data sources (OLTP).
The data from these OLTP are structured and optimized for querying and data analysis in a data warehouse.
5. Data mart?
a) A data mart is a subset of a data warehouse that can provide data for reporting and analysis on a section, unit or a department like sales dept, hr dept.
6. What is OLAP?
a) OLAP stands for online analytical processing. It uses databases tables (fact and dimension table) to enable multi dimensional viewing, analysis and querying of large amount of data.
7. What is OLTP?
a) OLTP stands for online transactional processing. Except data warehouse databases the other databases are OLTP.
These OLTP uses normalized schema structure.
These OLTP databases are designed for recording the daily operations and transactions of a business.
8. What are dimensions?
Dimensions are categories by which summarized data can be viewed. For example a profit summary fact table can be viewed by a time dimension.
9. What are conformed dimension?
a) The dimensions which are reusable and fixed in nature. Example customer, time, geography dimensions.
10. Staging area?
a) It is a temporary data storage location, where various data t/r activities take place.
11. Fact grain (granularity)?
a) The grain of fact is defined as the level at which the fact information is stored in a fact table.
12. What is a fact less fact table?
a) The fact table which does not contain facts is called as fact table.
Generally when we need to combine two data marts, then one data mart will have a fact less fact table and other one with common fact table.
13. What are measures?
a) Measures are numeric data based on columns in a fact table.
14. What are cubes?
a) Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis.
15. What are virtual cubes?
These are combination of one or more real cubes and require no disk space to store them. They store only definition and not the data.
a) The dimensions which are reusable and fixed in nature. Example customer, time, geography dimensions.
10. Staging area?
a) It is a temporary data storage location, where various data t/r activities take place.
11. Fact grain (granularity)?
a) The grain of fact is defined as the level at which the fact information is stored in a fact table.
12. What is a fact less fact table?
a) The fact table which does not contain facts is called as fact table.
Generally when we need to combine two data marts, then one data mart will have a fact less fact table and other one with common fact table.
13. What are measures?
a) Measures are numeric data based on columns in a fact table.
14. What are cubes?
a) Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis.
15. What are virtual cubes?
These are combination of one or more real cubes and require no disk space to store them. They store only definition and not the data.
16. SCD's?
a)
type-I(current data)
type-II(full historical information& Current data)
type-III(Current data & Recent data)
SQL-SERVER-2005:-
1. Surrogate key?
a) It is an artificial or synthetic key that is used as a substitute for a natural keys.
It is just a unique identifier or number for each row that can be used for the primary key to the table.
(It is a sequence generate key which is assigned to be a primary key in the system(table)).
2. Primary key?
a) It can be used to uniquely identify every row of the table.
Unique + not null
3. Foreign key?
a) It is a column r combination of columns that contain values that are found in primary key of some table.
It may be null, not unique.
4. ComposIte key?
a) It is a primary key consisting of more than one column.
4. Indexes?
a) It is an access strategy that is a way to sort and search records in the table.
Indexes are essential to improve the speed with which records can be located and retrieved from a table.
Types: - cluster index (can create only one index on table)
Non-cluster index (can create up to 249 indexes on table)
Unique index
Composite index
(Simple index, reverse key index, bitmap index, function index)
5. View?
a) It is used for data security reason
to reduce the redundant data.
6. Cluster?
a) 1-many access path.
Clusters are used to store data from Difference tables in the same physical data blocks.
7. Sequences?
a) It is used to quickest way to retrieve the data.
8. Cursors?
a) Implicit cursor
explicit cursor
Parameter cursor
9. Triggers?
a) Row trigger
Statement trigger
10. Transactions?
Save point
Commit & rollback.
11. Security?
a) Encryption
Locking
Level of locking row level, page level, table level
12.constraints?
primary
foreign(reference)
check
unique
a)
type-I(current data)
type-II(full historical information& Current data)
type-III(Current data & Recent data)
SQL-SERVER-2005:-
1. Surrogate key?
a) It is an artificial or synthetic key that is used as a substitute for a natural keys.
It is just a unique identifier or number for each row that can be used for the primary key to the table.
(It is a sequence generate key which is assigned to be a primary key in the system(table)).
2. Primary key?
a) It can be used to uniquely identify every row of the table.
Unique + not null
3. Foreign key?
a) It is a column r combination of columns that contain values that are found in primary key of some table.
It may be null, not unique.
4. ComposIte key?
a) It is a primary key consisting of more than one column.
4. Indexes?
a) It is an access strategy that is a way to sort and search records in the table.
Indexes are essential to improve the speed with which records can be located and retrieved from a table.
Types: - cluster index (can create only one index on table)
Non-cluster index (can create up to 249 indexes on table)
Unique index
Composite index
(Simple index, reverse key index, bitmap index, function index)
5. View?
a) It is used for data security reason
to reduce the redundant data.
6. Cluster?
a) 1-many access path.
Clusters are used to store data from Difference tables in the same physical data blocks.
7. Sequences?
a) It is used to quickest way to retrieve the data.
8. Cursors?
a) Implicit cursor
explicit cursor
Parameter cursor
9. Triggers?
a) Row trigger
Statement trigger
10. Transactions?
Save point
Commit & rollback.
11. Security?
a) Encryption
Locking
Level of locking row level, page level, table level
12.constraints?
primary
foreign(reference)
check
unique
13. Difference b/w having and where?
a) after performing 'group by' operation 'having will again filter the records based on having condition
'where' is used to filter the data based on a condition and It applies to retrieve on a particular column.
14. Joins?
a) Join can combine the information from two tables into a single unit.
Inner join:-
they matched the records together based on one or more common fields (matched-records only).
Outer join:-
full join:-It combines the all rows on both sides of the join.
Cross join:-
a) after performing 'group by' operation 'having will again filter the records based on having condition
'where' is used to filter the data based on a condition and It applies to retrieve on a particular column.
14. Joins?
a) Join can combine the information from two tables into a single unit.
Inner join:-
they matched the records together based on one or more common fields (matched-records only).
Outer join:-
full join:-It combines the all rows on both sides of the join.
Cross join:-
15. Union & union-all?
a) Union:-columns, data types should be same
Select distinct values
Remove duplicates
Union-all:-displays all the rows exact & duplicates.
16. Difference b/w drop, delete & truncate?
Delete:-delete all rows at a time
delete a single row data based on condition.
Memory allocation will be there
structure will be there
Truncate:-delete all rows at a time
can't delete single row at a time
memory allocation deleted
table structure will be there
Drop: - delete all rows at a time
can't delete single row at a time
memory allocation can be deleted
table structure also be deleted
MSBI
Online Training:
66 comments:
Thanks for sharing valuable information and it is useful for BigInfosys provides the best MSBI Online Training classes.
The information which you have provided is very good. It is very useful who is looking for MSBI Online Training.
Excellent Job Dear...
05
The information which you have provided is very good.
http://www.atoziq.com/2012/05/ms-bi-interview-questions-ms-bi.html
I’m not certain where you are getting your information, however great topic. I must spend some time finding out more or figuring out more. Thank you for fantastic
information I used to be looking for this info for my mission!. We are providing Online Training
Nice blog sir,
FREE SSAS Interview Book
http://www.interviewquestionspdf.com/2014/05/ssas-2012-pdf-ebook-free-download.html
very nicehelpful
very nice infromation
Free sql server questions
http://hksqlinterviewquestions.blogspot.in
This is one awesome blog article. Much thanks again.
I really enjoy the blog.Much thanks again. Really Great.
oracle online training
sap fico online training
dotnet online training
qa-qtp-software-testing-training-tutorial
Data Warehousing Interview Questions and Answers
http://allinterviewquestionsandanswerspdf.blogspot.in/2016/06/top-100-data-warehousing-interview.html
Hi,
Microsoft initiated the unique capability to use our in-memory column store delivering 100X faster queries with in-memory OLTP for real-time operational analytic and memory performance.
Thanks for sharing the valuable article. Don't delete this post it useful article.
This course is designed for professionals aspiring to make a career in Business Intelligence.
Software or Analytics professionals having background/experience of any RDBMS, ETL, and OLAP or reporting tools are the key beneficiaries of this course. visit http://www.ittrainingsonline.com/register for online demo
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MSBI, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on in MSBI. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
Sgraph Infotech is a Bangalore based complete training academy with strong placement Support. IT Training provided by software professionals with rich industry experience since 2005. Our core training Services includes Oracle DBA, SQL, PL SQL, MSBI, Power Bi, Devops..Etc
For More Information: Microsoft Business Intelligence Career
I just see the post i am so happy to the communication science post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be replay for your great thinks and I hope you post again soon...
MSBI Training in Chennai
very useful.thank you for sharing nice.Thank you for sharing MSBI Online Training
Thank you.Well it was nice post and very helpful information on MSBI Online Training Hyderabad
Very nice post here thanks for it I always like and search such topics and everything connected to them. Keep update more information..
MSBI Training in Chennai
Software Testing Training in Chennai
Thanks for the efforts on gathering SSRS useful content and sharing here.
Thank you very much for your good information. msbi Online Training Hyderabad
This is a great post. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this again.
Informatica Training in Chennai
Dataware Housing Training in Chennai
nice post msbi code is very easy to understand and it is very simple i also studying that.
thanks for giving this coding information.
msbi training in chennai
you have provided excellent information, Check it once for more information on MSBI Online Training Hyderabad
I am happy that I found your post while I was searching for MSBI Job Support. It is completely filled with great knowledge. Thanks for sharing!
Sain Bainuu,
In total awe…. So much respect and gratitude to you folks for pulling off such amazing blogs without missing any points on the MSBI ONLINE TRAINING BLOG. Kudos!
I am facing an issue with DBMS_CHAIN execution.
Issue :Even one of the step got Failed, remaining steps were processed with out waiting for depended step SUCCESS.
Just FYI: I created 2 chains i.e. Chain1 and Chain2 . Calling Chain2 as subchain in Chain1.
i attached the total script for your reference and below the run details.
In the below run_details , you can see STEP2 is in failed state but further steps(i.e. STEP3 of CHAIN1 and STEP1 , STEP2 of CHAIN2 got processed)
Please suggest me on this(what i need to do to hold at FAILED step and how can i RERUN that FAILED step only (or) from Failed Steps).
I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.
Many Thanks,
Irene Hynes
Nice information thank you, but more information please check it once
MSBI Training in Hyderabad
thank you for sharing this nice information .Thank you for sharing
Power BI Training in Hyderabad
POwer BI Online Training In Hyderabad
Power BI Online Training In Ameerpet Hyderabad
Nice explanation, if you want more information please visit our website.
MSBI Training in Hyderabad
This information you provided in the blog that is really unique I love it!! Thanks for sharing such a great blog Keep posting..
MSBI Interview Questions and Answers
Good information thank you
MSBI Training in Hyderabad
Learned a lot of new things from your post, It's amazing article
Sql server DBA Online Training
Really it was an awesome article… very interesting to read…
Thanks for sharing.........
bigdata hadoop training in ammerpet
Really it was an awesome article… very interesting to read…
Thanks for sharing.........
MSBI online training in UK
Nice blog,thank you for sharing your experience with us and your site is very genuine.
MSBI Training in Hyderabad
Very interesting Information on Digital marketing. And I Enjoy This Episode Today. Thank You.
thanks for sharing
msbi online training in hyderabad
Hi,
Thank you for sharingMSBI post.It’s very attractive and impressive.I like it your blog……
Thank you
priya
Dissertation Writing Services Ashford - Help in Dissertation is a remarkable academic portal that is known for offering extensive educational solutions. Parents can even Dissertation Writing Services Ashford.
Live Chat @ https://www.helpindissertation.co.uk/dissertation-services
Read More @
Dissertation Help Aberdeen UK
Buy Essay Online Belfast
Dissertation Services Belfast
Live Chat @ https://www.livewebexperts.com/services
Read More @ Assignment Help Florida
Online Tutoring Help California
Essay Writing Services Illinois
Economics assignment answers NSW – Help with Assignments is a well-known academic portal that offers high-end economics answer help to the universities and college students. Live Chat @ https://www.helpwithassignments.com/management-assignment-help
Read More @ Help with Homework Australia
Algebra Assignment Solver
Amellie Taylor is a renowned academician writing on a series of academic topics. He is associated with the UK Best Tutor, a reliable academic portal. Amellie Taylor is the title of today’s content.
Live Chat @ https://www.ukbesttutor.co.uk/our-services/dissertation-help-services
Read More @ Online Homework Help Bristol
Best Assignment Help Bristol
Online Essay Writing Bristol
Nursing Assignment Writer Kansas – The Best Tutors is a reliable academic portal that is known to offer exceptional educational assistance to the nursing assignment services students at a small price. Live Chat @ https://www.besttutors.us/medical-assignment-help
Read More @ Nursing Assignment Writer Kansas
Software Engineering Homework Help Alaska
Australia Best Tutor is available providing Help with Assignment Services Melbourne that help the students in preparing a relevant and innovative assignment paper. These experts are highly efficient and well trained.
Live Chat @ https://www.australiabesttutor.com
Read More About
Assignment Help Melbourne
Help with Assignment Melbourne
Mathematics Assignment Help Melbourne
Engineering Assignment Help Melbourne
My Homework Help Services Australian Territory – Help with Assignments is a reliable academic company offering high-end direction and help to the students pursuing homework help at a very reasonable price.
Live Chat @ https://www.helpwithassignments.com/homework-help-services
Read More @ Economics Help Online Victoria
Management Assignment Help Victoria
Nursing Assignment Writer Arkansas – The Best Tutors is a best academic portal that is known for success help in completing assignment services to the students. Live Chat @ https://www.besttutors.us/medical-assignment-help
Read More @ Forensic Accounting Homework Help Alaska
Pre- Calculus Homework Help Alabama
Thank you very much for your good information. msbi Online Training
My Genius Mind is a reputed academic concern that extends best professional Assignment Help to the students. This service can be availed at any time anywhere.
Live Chat @ https://www.mygeniusmind.com/my-assignment-help
Read More Information @ Accounting Assignment Help Brisbane
Boston South Australia Assignment Help
Mandurah Western Australia Assignment Help
NewCastle NSW Assignment Help
Best Assignment Help NSW – Help with Assignments is best My Assignment custom firms make sure to send unique content. They assume severe research and provide sincere work permanently.
Live Chat @ https://www.helpwithassignments.com/
Read More @ Business Finance Assignment Help Victoria
University Nursing Assignment Help Queensland
Homework Help Services Victoria
The Best Tutors is a remarkable academic portal that is known for offering online dissertation services responses to the subtle students.Live Chat @ Essay Writing Services Arizona
Read More @ Nursing Assignment Writer Arkansas
Assignment Tutoring Help Alabama
Australia Best Tutor is offering online assignment help services Australia at affordable price. Here students are joining for best academics grades and good quality content.Services are under below
Engineering Assignment Help Brisbane
Management Assignment Help Brisbane
Assignment Writing Services Brisbane
Nursing Assignment Help Perth
Finance Assignment Help Perth
Live Chat @ https://www.australiabesttutor.com
UK Best Tutor is one of the famous and trustworthy academic portals that is known to provide the students with Assignment Help Scotland directly and successfully.
Live Chat @ https://www.ukbesttutor.co.uk/
Read More @ Online Assignment Writing UK
University Assignment Help UK
Assignment Help Tutor England
The Best Tutors is one of the well-acclaimed and celebrated academic portals that offer the Math Homework Help. These services are the rapid and affordable price.
Live Chat @ https://www.besttutors.us/mathematics-homework-help
Read More @ Civil Engineering Homework Help Arkansas
Internal Auditing Homework Help
Appreciative to you, for sharing those great expressive affirmations. I'll attempt to do around a prodding power in responding; there's a striking game-plan that you've pulverized in articulating the critical objectives, as you charmingly put it. Continue Sharing
Big Data Hadoop online training in Bangalore, Chennai
Online Hadoop training in Delhi, Pune
Live Web Experts is a favourite educational website that has gained a lot of reputation for submission eccentric Homework Help Online to the students.
Live Chat @ https://www.livewebexperts.com/homework-help
Read More @ Finance Textbook Assignment Illinois
Assignment Help Experts Alaska
Help Me Write A Paper Taxes
hi your blog Article is very nice & thanks for sharing the information.
powerbitraining
powerbitraining in ammerpet
powerbitraining in hyderabad
yours blog was excellent and really enjoyed.Thanks for sharing and mainting blogging
Data science online training in Hyderabad
Data science training in usa
Data science training in uk
Best Tutors, The students can obtain help from the professional and expert authorities with abundant knowledge, which is given by us as a reliable and popular engineering homework help earner.Live Chat @ https://www.besttutors.us/engineering-homework-help
Read More @ Geometry Homework Help Colorado
Finance Homework Help Colorado
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site
data science online training
best data science online training
data science online training in Hyderabad
data science online training in india
Such an informative post. Thank you for sharing
Online Project Server Solution Australia
Thanks for sharing such a great blog Keep posting.
CRM software
online CRM software
b2b data companies
sales automation process
Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
Msbi online training Hyderabad
Msbi online training India
Msbi online course
Msbi training online
Very useful post and I think it is rather easy to see from the other comments as well that this post is well written and useful. I bookmarked this blog a while ago because of the useful content and I am never being disappointed. Keep up the good work..
AWS cloud training in Gurgaon
FullStack Development Training in Gurgaon
Post a Comment