Link to home
Start Free TrialLog in
Avatar of dplowman
dplowman

asked on

Help with questions for job interview tomorrow!

All,

I just found out this morning that I am having an interview tomorrow afternoon. I was given some advice as to what to review. If any of you can supply links or answers to the following would be appreciated!

Be prepared for questions on:

- Ad hoc Query
- Building Stored Procedure
- Indexing
- SSIS package with few of the data transformations
    Excel to OLEDB
    Look up Transformation
    data type conversion
    File copy/move/delete control flow transformation
    Union/Merge transformation
- Reporting deployment in BOE(SAP business object enterprise)
- over all difference between different types of joins in query.
- Pros and Cons. of Indexes on database tables.
- Documentation tool(TFS, Sharpoint etc)
- Requirement specification document (what type of information you would collect from the end users for report building)

Thanks
SOLUTION
Avatar of Rajendra Shekhawat
Rajendra Shekhawat
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dplowman
dplowman

ASKER

Thanks, I will award points shortly. Also, could someone answer this question.

what type of information you would collect from the end users for report building?

Thanks!
Thanks for the advice!
Avatar of Jim Horn
dplowman - I just wrote an article called SSIS Interview Tips and Tricks, let me know if you like it.