SSIS Interview Questions.
Nov 27, 2006Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions.
Thanks
ADVERTISEMENT
SQL 7 Interview Questions
Feb 23, 2001Hi,
I was wondering if some one would be able to help me?
I'm interviewing a SQL Admin soon and I'd like to ask him some
SQL 7 questions to test his knowledge. He has less than a year
of experience. Does anyone know any good questions I could ask him?
Please e-mail them if possible. I appreciate any help that could be provided.
Thanks,
Jim
Interview Questions
Feb 14, 2007hi,
i have been attending interviews and jotting down a couple of questions that were asked to me. could someone please answer to these..it would be of gr8 help..
Q 1> give example of situation when & why u would use clustered and unclustered index. not the definition a practical example.
Q 2> a website has a lot of users using it and the pages are loading very slowly what would you check..
i said would look for deadlock , the next question how would you look for dead lock?
i answered would check on the stored procedure on that page, question what if there are multiple stored procs then what would you do?
Q 3> what if u have a dts package and execute SQL task and there is a stored proc that is doing inserts on a table and that table has triggers on
it for insert, delete etc.so would the triggers also be executed with the dts package run?
thanks.
Some Interview Questions
Mar 29, 2008Hi to all. Recently i attended an interview .I have so many doubts ,could any one tell me about these questions.
1.) How to identify a query which is used by end user with out profiler. (the exact query)
2.) my tempdb is full what to do.
Then i said i will restart the server
then he asked My company is not allowing to restart the server.then what we can do?
3.) Transaction log is full what to do ?
4..How can we improve the performance of database.
5..how to rebuild the master database if it is corrupted.
6.. what new features are introduced in log shipping in 2005.
7..how can we give a permission to a userto use only profiler. he is not allowed to do any operations
8..after finding long running queries the next stop what we can do?
9..what i can do if my secondary database is no in sync with primary database in log shipping.?.
10..if the quereader agent fails will the transactional replication completely fails or partially fails.
11..how to replicate identity column in merge replication?
Waiting for ur replies,
Sripathi
DBA Interview Questions
May 29, 2006DBA Interview Questionshttp://quickdba.blogspot.com/2006/0...-questions.htmlVisit for more Articles
View 3 Replies View RelatedContractors Questions In Interview
Nov 2, 2000Any suggestions for some really juicy questions to ask contractors in an interview scenario?? What are your best questions any further ideas would be nice to hear. Cheers.
View 1 Replies View RelatedSQL Server Interview Questions
Jul 20, 2005Hi,Is there any website which lists the various SQL Server relatedquestions which might be helpfull for interviews. I am looking forone that contains complex Queries that includes all kinds of operatorslike GROUP BY, HAVING etc...Regards,Kamlesh
View 6 Replies View RelatedBEST SQL Interview Questions Site
Sep 6, 2007Hi,
Can anyone tell me the BEST interview Questions site for SQL 2000 and for SQL 2005, BOTH versions.
I Want The Sites For ASP.NET 2.0 And SQL SERVER 2005 Interview Questions.
May 12, 2008I want the sites for ASP.NET 2.0 and SQL SERVER 2005 interview questions.
2) Sites for SQL SERVER 2005 concepts
SSIS Interview Question
Mar 15, 2007Does anyone has, a list of interview questions for SSIS? Or can somebody list possible SSIS interview questions?
------------------------
I think, therefore I am - Rene Descartes
Interview Question-How To Identity Existing Data For Updating In SSIS?
Feb 26, 2008I have met the interview question, I provide answer like the following from my experience. I don't know it is correct or need to supplement. Thank you for help.
Question: How to identity existing data for updating in SSIS?
Answer:
If you have the same key columns such as primary key or business key, you just use them to identify existing records from data source to destination.
If you use different key columns between data source and destination, you can create permanent link table which will store business key for data source and destination, and you can compare records from linking table when you update data.
SSIS Questions
Mar 4, 2008Hi all,Can you please share some interview questions that can be expected on SSIS 2005?
View 8 Replies View RelatedSSIS ETL Questions
Mar 23, 2007I am using SAS Dataset and loading in to SQL server 2005.Now i want to delete columns which have 0 values and null values.Can anyone guide me how to do this?thank you.
View 3 Replies View RelatedConverting DTS To SSIS - 2 Questions
Apr 11, 2008Hi,
I was wondering if anyone know how to do Dynamic Properties Tasks in SSIS? And, does anyone know how to create a global database in SSIS so I won't have to change all of the database names in my package? I'm sorry, I'm new to SSIS and I'm just really frustrated. Thank you.
SSIS And Security - Questions
Mar 15, 2007Hello,
I realize that I am confused about SSIS and security.
In BIDS, I work on and modify my packages. That part I understand. Then, I want to build my project, then deploy to SQL Server 2005. I know how to do that too (for the most part, please see below):
My confusion arises around the "Protection Level" options in the package properties. Right now I have everything set to "EncryptSensitiveWithUserKey". My understanding is that I need to change this in order to run my packages from SQL Server jobs, because only the creator of the package can currently run the job.
So my question is, since I want to deploy to SQL Server, don't I want to change the "Protection Level" to "ServerStorage"?
However, it will not let me change the protection level to ServerStorage. It says "The protection level, ServerStorage, cannot be used when saving to this destination"... presumably because it is attempting to save to the file system.
However, even when I built out my packages and saved to SQL Server, I could not change the protection level either.
Which is why I am really confused... Once you save your packages to SQL Server, how do you make changes to the packages, so that the changes are reflected in the packages stored on SQL Server?
There is some concept I am not understanding here.
Thanks for any help
Questions On SSIS Tool.
Sep 28, 2007
I have some questions on SSIS tool I tried to read many docs to understand SSIS.
Now I am looking forward for below questions.
How to use SSIS for :
1. How to Export data from SQL Server 2005 in to Access database using SSIS?
2. How to Import data from Access .mdb file to SQL Server 2005 database using SSIS?
3. How to Import Oracle10g data in to SQL Server 2005 databvase using SSIS?
4. How to Import Oracle10g Data to Access file using SSIS?
5. How to Import SQL Server 2000 data in to SQL Server 2005?
It will be great to have step by step explanation.
Thanks in advance.
SSIS Boolean Questions
Oct 24, 2006Please write YES/NO against point number in your answer i.e. for example:
1) YES, 2) YES, 3) NO, 4) YES etc.
We have source SQL Server 200 databases in one instance and target SQL Server 2005 in another instance both being on different windows 2000 server systems.
Target OLAP DB design is derived from source OLTP.
Most master & transaction tables are as is but some target tables are a result of merging source tables.
We need to do SSIS packages based migration using data flow task based on column mapping & queries using Business Intelligence Development Studio (BIDS). There are no transformations required.
1) Can I group packages under project into sub-groups i.e. super packages?
2) Can I execute a set of packages together which are logically/physically grouped?
3) Can we execute set of ordered packages/individual packages from command line and even
stored procedure?
4) Can we maintain transaction integrity across the entire set of ordered packages we execute?
5) Can we send a mail to mail id(s) in case of events like OnError etc.
6) Can we schedule the packages?
7) Does SSIS provide via BIDS a way to compare data in source with target to decide what got
inserted/deleted/updated and based on that do the necessary?
8) Can SSIS packages be developed including code for data encryption?
9) Can we pass parameters to packages that get called from stored procedure?
10) Can we call stored procedure/function in SSIS package?
SSIS Related Questions
Nov 7, 20060) We are migrating data from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design.
1) We have an data flow task SSIS package.
2) We managed to send a mail with various variables & their values in subject or body of mail.
3) How do we send mail with details of Error/Warning using OnError/OnWarning events?
4) Can we have bad tables i.e where records which failed to migrate get inserted into. If yes, what are the steps to implement this.
5) Can we have a mix of in-built & custom logging. Is logging provider necessary to do logging. What logging provider to use?
6) Where are the errors that come during build, deploy, install and execute stored? Is there a log file(s) & what it their location?
7) Please post links if that is better.
Some Basic SSIS Questions
Jan 18, 2008I have been working with SSIS and find myself stopped on what seem like very basic tasks.
Am I right in thinking that, if you want to import a flat file into a SQL datatable, in most PC based systems, that you have to manually cast EVERY SINGLE COLUMN to unicode string, if you don't want to get the 'cannot convert between unicode and non-unicode string data types'? I mean, this is surely a VERY COMMON task, taking a CR/LF delimited ASCII file and dumping it into a database tables? What if you have 50 fields to import?
Am I the only one who finds it very difficult to cast a string from a textfile to a date format? At this point, I always just dump the date to a 8 character string and save it that way, and use a SQL view to cast it to a date. At least SQL Server can do 'basic date conversions'. Is there any way to freeze execution and find out what data was provided to a derived column, if you're trying to do some substring operations and hodge together a date? I couldn't find any. I usually put a extra column in a datatable and plunk some data there to find out 'what it looked like', how else can you debug an SSIS program?
Is there a planned service pack or update to SSIS that will make this more usable? Does Microsoft ever intend to implement an UPSERT type module? Or a File Move operation that handles directories that fill up with log files, each of which have to be added to a datatable and then moved to an archive directory (surely, another very common task - I figured out how to accomplish this but it is far from intuitive, the way it currently works). Sorry for grumbling, but honestly, I find turnaround time to develop a very simple import program is RIDICULOUS. It's quicker to write a COBOL program to issue a bunch of formatted SQL UPDATE statements than using this application.
SSIS DTC Transaction's HOT Questions
Dec 8, 2006I am using SSIS with Transaction, and I met a lot of questions as below:
1.IF DTC doesn't support ADO.NET Connection?
Please check the ADO.net Connection's property, it has a property named like: DTCTrancactionSupport. But it's always set to False and unable to edit.
IF the answer is NO, HOW could I bound all my Tasks into one Transaction? You know, I have some Tasks with SQL connection, and I have also some Script Tasks, witch need the ADO.net connection.
2.IF DTC required to run in both the Destination Server and the Source Server?
I have a Dataflow Task, and take some data from a table in a Source Server to a Destination Server. The DTC doesn't run on the Source Server. I found the Dataflow Task hangs when I use the SSIS Transaction(just set the Task's transactionOpion to Required, Only one Task in the Package).
3.IF DTC doesn't support RetainSameConnection?
Many people say that. Really?
4.When a DTC transaction is running, if the table in it could not be modified by process outside of the transaction? For example, a package with a DTC transaction, and there is a SQL Task inside, when it is running, could I modified the same table's data manually(in the Sql Sever Management Studio)?
Couple Of Basic SSIS Questions
Dec 4, 2007Hello all, this is my first post, I have a couple of basic questions regarding the use of SSIS. I have used SSIS for a couple of years for on off table loads but never implemented production jobs with it so please bear with these questions.
1. When making scripts that connect to one or more databases, is there a way to store the userid and password somewhere besides embedded within the package, such as a web.config file, this would make routine password changes much more manageble.
I guess it was only one question but any help would be greatly appreciated.
Thanks.
Where Is The Forum For DTS -&&> SSIS Migration Questions?
Jan 29, 2008I have a question regarding a DTS (SQL server 2000 package) to SSIS (SQL SERVER 2005 package) migration.
which is the best forum to post my question ?
Simple Vb / Ssis Data Type Questions
Mar 27, 2007I have a some raw data in a string that looks like
'1989'
I need that to become numeric 19.89
if I define a type double for rawAmount
and do this:
rawAmount = CInt(iRest.Substring(41, 4))
Row.amount2 = rawAmount / 100
where row.amount2 is a type double precision float from my script component task output, I get:
19.899999999999999
what output should i use in this data flow component to get 19.89.
thanks.
Newbie Questions About SSIS Script Components And Data Streams
May 10, 2007The following is a list of questions that I have not been able to obtain concrete answers. I am probably missing something:
1) ReadWriteVariables -- can the updated value for a ReadWriteVariable be accessed within the same data flow? It appears not as I think the PostExecute() fires at the completion of the data flow not the end of the Script Component. Secondarily, the Script Component is a non-blocking transformation so the component does not "see" the end of the pipeline prior to sending data down stream.
2) Record Count -- Because of #1 above, How could you calculate a record count for a data stream? It does not appear that one can calculate the number of records for a data stream within a data flow and then access the count from within the same data flow.
3) FinishOutputs() -- Is the concept of FinishOutputs() applicable to Script Component Destinations? Asked another way, is FinishOutputs() executed at the end of the data stream regardless of whether there are "real" outputs for the component? I can create a "Dummy" output to create FinishOutputs() but is this ok?
4) Script Component -- It appears that the Script Component Source, Transformation or Destination are really defined based on the columns defined in "Inputs and Outputs". Can you convert an Source script component to a transformation script component by simply adding an Output?
Sorry for these basic questions but I am not getting it completely. As you can tell...
Interview
May 8, 2004Good fortune came my way this morning I was invited to an interview for a Database Administrator/IT Support position with a local charity.Although my 2 years experience with IT has been mainly supporting desktops Win 98,2K ,XP in a workgroup together with training users on MS Office Professional I decided to go for the database admin/IT support because I want to broaden my experience with IT applications. The objective being to become more marketable to employers.While I definately meet most of the IT support/training requirements for the post a few requirements are making me nervous because I have no experience in them since I believe I may need programming and or other skills which I don't have. The accountabilities that make me nervous are the following :
1. Devise and implement solutions to corrupted data and software inconsistencies or failures of the housing database.
2. Devise and implement solutiions to corrupted data and software inconsistences or failures of the management information system.
3. Devise and deliver reports from the housing database or MIS in order to satisfy the requirements of managers and external regulatory bodies.
4. Test and validate new versions of software.
Do I need database programming skills for these requirement?If not what skiils do I need and what would be the best way of answering quetions about these requiremnts during interview since I have no database admin experience ?
Looking forward to your thoughts on this.
Eastfield
Interview
Apr 11, 2008Hello everybody,
I'm new to SQL Server,I have a interview tomor,could anybody give me a website from where i can get questions on SSRS.
Thanks in advance
Interview Advice?
Jun 4, 2001Help please? Does anyone have any suggestions for me in regards to my first interview for a SQL DBA position. I will be meeting with the technical team including developers and IT professionals as well as the hiring manager. I want to make sure I as the right questions and have the correct answers. This is my first interview for this type of position. What are good questions? Any help or advice would be greatly appreciated.
Jerry
Interview Question
Aug 19, 2004here is a question asked in a interview:
u created the sales database with the initial size of hte transaction log of 50 mb with autogrow, but no autoshrink
u do not make any backup and donot set the truncate log on check point option to on.
what will be the transaction log size after the next check point has passed?
Interview Question?
Feb 23, 2004How many tables can be updated with a single update ?
View 14 Replies View RelatedInterview Question
Feb 23, 2004when does sql use update lock?
View 1 Replies View RelatedThis Is Interview Question...
Jun 3, 2008Hello
Can any one help me for below question....
" write a query using FOR UPDATE syntax "
Thanks
Ganesh
Solutions are easy. Understanding the problem, now, that's the hard part
Interview On Sybase
Jul 5, 2006Hi,
I know sql and Dataware housing.I got a job offering for sybase sql but I don't anything about sybase.Will it be in programming in Actually what we will do in sybase? What will be the nature of work? and I just want to know what type of question will be asked ? Please do reply.
Regards,
Raji
Interview Related
Dec 10, 2007Dear All,
Could anyone guide me to prepare for the Interview in SQL SERVER 2005.
I have studied the relevant things from background knowledge from the SQL Server books. But is there any specific areas in which I have to concentrate for the sake of Interview?
Thanks in Advance.