Help me out gurus! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Help me out gurus!

Author

Topic

jscot
Posting Yak Master

106 Posts

Posted - 2010-04-07 : 23:01:12

I have few interview questions, I want easy and straight fwd ans, Please some one can help me. I really appreciate.
1) How did you perform incremental load
2) How did you test your packages.
3) How did you deploy them
4) How did you optimize SSIS packages
5) How do you process your cube. what are the processing options we have.
6) How do you optimize your cube performance.
7) Which SDLC methodology you prefer and why.
8) What are different ways of Processing a Cube?
9) Why do we store Aggregations?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-07 : 23:16:15

If you don't know the answers, then perhaps you shouldn't be interviewing for the job. Do you have any SSIS or OLAP experience?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jscot
Posting Yak Master

106 Posts

Posted - 2010-04-07 : 23:19:41

I don't have real practical exp, i creates dw, create packages, cubs, reports now i m going to prepare my self for interview. To find out these questions.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources