how to explain ssis project in interview ? [Resolved]

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




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(E xtract), process that (which is the T ransformation) and then loads the same to the destination(L oad). 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.

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) A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation [ http://www.codeproject.com/Articles/188075/A-Palindrome-Program-in-SSIS-using-Copy-Column-Der ]

Kindly let us know if 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
Mainly say how you write your queries in optimized manner and how you debug when you face some issue and also say the version of development studio you have used and follow Same what I explained in other question of yours,

Be strong in Joins and SQL, Jobs execution and Package creation in SSIS

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.



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 so much



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

Login to post response