SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

When we think about creating any SSIS package, after we open the SQL server data tools or Business Intelligence development studio we will landed into SSIS designer window.

SSIS 1
As you can see SSIS designer contains many tabs at the top. Work will always start with Control Flow. In control flow we add different kind of tasks to achieve different functionalities. One of those task is Data Flow Task which will let us define our ETL Process.

Just take Data Flow task from toolbox and drag into the Control Flow tab area. Now double click the task and it will take us to Data Flow tab.

SSIS 2
Data Flow let us define the flow of data from source to destination.

What all components we can add in Data Flow Tab?

There are three types of components which we can add in Data Flow tab.
Sources – Let us define the source repository from which data is going to be fetched.
Transformations – Let us convert or modify the data retrieved from source as per business requirement.
Designations – let us define the destination repository where data will be transferred.

What will be used in Data Flow tab to show the Flow of data?

We use the green arrow coming out of source and transformation components. This green arrow is termed as Data Flow Path.

If you are looking for a step by step article on Microsoft Business Intelligence you can start from here.

For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF and UML and many more feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com

For more stuffs like this click here. Subscribe to article updates or follow at twitter @SukeshMarla

Also see another SSIS, SSAS and SSRS(MSBI) interview questions video on basics of SSIS , SSAS and SSRS: –

Advertisements

About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- https://www.youtube.com/watch?v=Lp7nSImO5vk Learn AngularJS Step by Step:- https://www.youtube.com/watch?v=0kmdjqgO9IY Learn Design Pattern in 8 hours:- https://www.youtube.com/watch?v=YDobmucohqk Learn C# and .NET in 60 days:- https://www.youtube.com/watch?v=yh2SrzCkNQA Learn MSBI in 32 hours:- https://www.youtube.com/watch?v=mGPJx3ocFgg Learn SharePoint Step by Step in 8 hours:- https://youtu.be/C2fW76SwJNU
This entry was posted in Uncategorized and tagged , , , , , , , , , . Bookmark the permalink.

One Response to SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

  1. Pingback: Tabs in the SSAS cube designer | Just Compile

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s