SSIS Interview Questions

SQL Server Integration Services Interview Questions

What is SQL Server Integration Services (SSIS)?

Allows you to develop data integration and workflow solutions. Apart from data integration, SSIS can be used to define workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases.

How does SSIS differ from DTS?

SSIS is an upgraded version of DTS (Data Transformation Services) and has been completely re-written from scratch to overcome the limitations of DTS.

What is the Control Flow?

When you start working with SSIS, you first create a package which is nothing but a collection of tasks or package components. The control flow allows you to order the workflow, so you can ensure tasks/components get executed in the appropriate order.

What is the Data Flow Engine?

The Data Flow Engine, also called the SSIS pipeline engine, is responsible for managing the flow of data from the source to the destination and performing transformations (lookups, data cleansing etc.). 

Data Warehouse Interview Questions

DataWarehousing Questions

What is a Data Warehouse?

A data warehouse is a storage of historical data for Data Analytics, such as reporting, analysis, Integration and data management. A data warehouse is a repository of data.

Benefits of Data Warehouse?

It intergrates data and stores the data historicaly so the data can be analysis for performance, trends, predictions over a period of time

What is Business Intelligence?

Business Intelligence is presenting historical data in a meaningful way (often by using different data visualization techniques). Raw data stored in databases can turn into valuable information through the ETL Process.

What is the difference between OLTP and OLAP?

OLTP is the transaction system that collects business data. Whereas OLAP is the reporting and analysis system on that data.

OLTP systems are optimized for INSERT, UPDATE operations and therefore highly normalized. OLAP systems are deliberately denormalized for fast data retrieval through SELECT operations.

Roasted Vegetable Lasagna

Roasted Vegetable Lasagna is a classic dish all around. It does take a little time to make, but tastes wonderful.

Ingredients

1 Eggplant (Big, Round and Lightweight)
1 Yellow Squash
1 Zucchini

2 Onions
1/2 Bell Pepper
1/2 Red Pepper

1 Teaspoon Black Pepper
1 Teaspoon Paprika
1 Teaspoon Salt
1 Teaspoon Onion Powder
1 Teaspoon Garlic Powder

2 Tablespoons Roast Vegetable Seasoning (available at most farmers markets)

10 leaves of Basil

Red Chili Flakes
Oil

3 Handfuls of Shredded Mozarella Cheese

1 Box of Barilla Oven-Ready Lasagna Sheets

1 Bottle of your favorite pasta sauce. (I use Vodka Sauce)

Honey Chili Chicken Wings

Chili Chicken Wings is another favorite of ours. All the kids in our family love it, as well as the adults.

Not many things are needs in making these wings, and its great as an entree or as an appetizer. I generally make these as an appetizer but my sister in law makes them as the main item as part of there main dish. Either way, they are delicious. Definitely worth trying out.

The brown you see on the wings is actually caramelized Honey, which gives these wings the added flavor.

Marinate Overnight or for at least 3-4 Hours.

INGREDIENTS

Chicken Wings (Approx 20- 30 Wings)

1 Tablespoon Minced Ginger
1 Tablespoon Minced Garlic
1 Tablespoon Chili Powder (Only if you can handle spice well)
1 Tablespoon Salt
1 Tablespoon Tumeric
1 Tablespoon Coriander Cumin Powder

1/2 Cup of Honey
1/2 Jar of Vietnamese Chili Garlic Sauce(8oz) 
     (Any Sweet Chili Sauce or Chili Sauce works)
I use the following :