how to explain project flow in interview ? on ssis [Resolved]

Posted by Chamu under Sql Server on 7/27/2016 | Points: 10 | Views : 673 | Status : [Member] | Replies : 3
how to explain project flow in interview ? on ssis




Responses

Posted by: Rajnilari2015 on: 7/29/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Sql Server Integration Services (SSIS) is an ETL tool.

In simple words, what an ETL does is that, it extract the Raw information, process that (which is the Transformation) and then loads the same to the destination. e.g.

Given a flat file(say input.txt) that contains some valid and invalid email address, we need to load the valid emails to another text file (output.txt). For that, the Source will be input.txt. Next we have to extract the source data from input.txt. Then have to filter the valid records i.e. transform. And finally push the same to the destination file which is output.txt.

SSIS has many components broadly classified into Control flows and data flows.

After explaining this basic of SSIS, we have to explain the interviewer, the business purpose for the usage of the SSIS package, which components you have use to design that, how you have tested your package and finally deployment.

Having explained, then you also need to tell him how you are invoking the package (i.e. about the hosting environment).

If you have done any performance optimization, please mention that too.

You can also refer to a couple of my SSIS articles, for a more clear picture

1) An indespensible SSIS transformation component - Script Component [ http://web3.codeproject.com/Articles/193855/An-indespensible-SSIS-transformation-component-Scr ]


2) Working with Pivot and UnPivot Transformation [ http://www.codeproject.com/Articles/193842/Working-with-Pivot-and-UnPivot-Transformation ]

And try to explain the same to yourself by following the approach mentioned above.

Hope that helps.

--
Thanks & Regards,
RNA Team

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bhuvanesh6 on: 7/29/2016 [Member] Starter | Points: 25

Up
0
Down
Just you start explaining the project functionality in high level and explain the architecture and its scope for future enhancement that will be fine.
The main point that you have to highlight here that what you did special to the project like any special features or some enhancements that you have suggested and client appreciated or the task which was very challenging and that you resolved by thinking out of box this is what is expected more in an interview than knowing about your project functionality.

This is common for SSIS or Java or .NET or any project


Bhuvan

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Chamu on: 8/4/2016 [Member] Starter | Points: 25

Up
0
Down
thank you all.

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response