Interview questions

Question

Interview questions

karunakar2351

Right there with Babe

Points: 729
More actions
September 25, 2014 at 11:40 am

#397403

Hello Friends...
My recent interview questions..
1.If we have a text file,excel file,.csv file in one folder..How do you load these 3 files data into a single destinition table..
2.I we have a 3 text files in a folder but the structure of those 3 text files is different.How do you load these 3 files data into a single destinition table.
3.we have a scenario like....one source file is from one server and another source file is from another server and one more source file is from one more server How do you load these 3 source files data into a single destinition table???
4.what is a CTE?
5.In a flat file contains 1000 rows after loading 500 rows we got an error How do you load the rest of rows into a destinition table?
6..In a flat file contains 1000 rows How do you load the first 500 rows into one destinition table and the rest of rows into another destinition table?
7.How can you handle the error handling in ssis?
8.What is ON_EVALUATE EXPRESSION PROPERTY in ssis??
9.If one package is containing in one system another package is from another system ,Is it possible to get that package from other system to my system???
10.How to check the how many temporary table are present in a database or not????

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

karunakar2351 (9/25/2014)
Hello Friends...
My recent interview questions..
1.If we have a text file,excel file,.csv file in one folder..How do you load these 3 files data into a single destinition table..
2.I we have a 3 text files in a folder but the structure of those 3 text files is different.How do you load these 3 files data into a single destinition table.
3.we have a scenario like....one source file is from one server and another source file is from another server and one more source file is from one more server How do you load these 3 source files data into a single destinition table???
4.what is a CTE?
5.In a flat file contains 1000 rows after loading 500 rows we got an error How do you load the rest of rows into a destinition table?
6..In a flat file contains 1000 rows How do you load the first 500 rows into one destinition table and the rest of rows into another destinition table?
7.How can you handle the error handling in ssis?
8.What is ON_EVALUATE EXPRESSION PROPERTY in ssis??
9.If one package is containing in one system another package is from another system ,Is it possible to get that package from other system to my system???
10.How to check the how many temporary table are present in a database or not????

So did you research these? What answers did you come up with?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Fair collection of questions. So what were your answers to them?

When you researched them after the interview, did you come up with anything that you're not sure you understand or want to discuss?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

My answer to a number of these questions would start with: "Well that depends. Can you elaborate on what you mean by ..."

Some questions are rather vague, just like the questions in this forum. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]