Advanced SQL tutorial pdf, Define below transformation in DFD?, Difference between Cached Report and Snapshot Report, Download SQL Questions, Download SQL Server Interview Question in PDF, Download SQL SERVER Interview questions, Download SQL Server Interview questions and answers, download sql server interview questions and answers pdf, download sql server interview questions by Pawan Khowal, download sql server interview questions by Pawan Kumar, download sql server interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL SERVER Interview questions, How many type of protection level in SSIS package?, How to create Temporary Table using SSIS?, How to make connection with a FTP server?, How to show "No Data Found" Message to end user?, SQL, SQL Common Interview Questions, SQL Common Interview Questions and answers, SQL FAQ, SQL FAQs, SQL Interview Q & A, SQL Interview Questions, SQL Queries asked in interviews, SQL Questions, SQL Server - General Interview Questions and Answers, SQL Server developer Interview questions and answers, SQL Server developer Interview questions with answers, SQL SERVER Indexes, SQL SERVER Interview questions, SQL SERVER Interview questions & Answers, SQL Server Interview questions and answers, SQL Server Interview Questions and Answers - Free PDF, sql server interview questions and answers for net developers, SQL SERVER Tips, SQL Tips & Tricks, SQL Tips and Tricks, SQL Tricks, T-SQL Server Interview Questions, What are Attunity Driver and why do we user in SSIS?, What are check point and how they work? How check works in for loop?, What are Lazy aggregations?
SQL Server (SQL,SSIS,SSRS,SSAS) Interview Questions – # 6
Last week, I have given a technical interview for a company based out from Gurgaon. So with out further delay I will list the questions-
- I have a sql table that I need to split into more 90 excel sheet based on a code. I could create an ssis package and use conditional split and create more than 90 excel sheet. But creating more than 90 excel sheet one at a time will be time consuming and if I have to use that package again for another table then I would have to make changes. Is there an easier/faster way to achieve split a table into more than 90 excel tabs? Is it possible to use foreachloop and dynamically split and create excel tab?
- What are Attunity Driver and why do we user in SSIS?
- How many type of protection level in SSIS package?
- Difference between Cached Report and Snapshot Report
- What are check point and how they work? How check works in for loop?
- Define below transformation in DFD?
a. Character Map
b. Merge vs. merge join Vs. Union ALL
c. Cache transform
- How to show “No Data Found” Message to end user?
- Can we apply style sheet in SSRS and how?
- What are Partition processing options?
- Can we debug SSIS package. If Yes, How?
- We get the files in our Source Folder all day long. Each file is appended copy of previous file. We want to create a SSIS Package that will load only the most recent file to our table.?
- How to create Temporary Table using SSIS?
- What are Lazy aggregations?
- How we can ignore failure and continue loop in SSIS?
- How to make connection with a FTP server?
- Difference between Report Server and Report Manager
- I need to build custom Logging for our all SSIS Packages. We want to insert some information in a table at start of the SSIS Package and then at the end we want to update the record with “Package Completed successfully” or “Failure”. What you do?
- What is the difference between NON EMPTY keyword and NONEMPTY() function?
- Sometime we need to debug out SSIS Package but we do not want to insert records in destination but still we want to use all the transformations and dump these all records in some dummy destination. The goal can be to check the extraction performance from source OR view data at different points of Package but we do not want to insert data in destination at all. What would you do?
Shall update the answers very soon !
Cheers, Thanks for reading !