Gave me a box of legos and had me build a tower as high as I could in 3 minutes that'd hold a cell phone for at least 10 seconds. After I did this they told me to make it higher. Then they had me make it even higher.
Developer Sql Server Etl Interview Questions
728 developer sql server etl interview questions shared by candidates
Describe in detail the system tables you'll need to query against to build documentation from the ground up for an undocumented series of database tables, and which fields would be key from those tables?
Its average yet managed to crack
Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?
why your company decided to have DB2 and SQL server database ?
All ETL questions, scenario everything
what is left join then said reverse this and what join it will be ? What are cursors? What is Rownum ? You have two tables , A and B ? A has two attributes , one is PK and other is FK and Table B also has two attributes, One is PK and other is FK. Now how to Insert the row. You have two parameters . one has value pen and other has value as pencil. Now how you swap the values without using Update stmt.
One instance where you increased the performance of your developed code
If I was given a service ticket outline the steps I would go through to resolve the issue.
1)SCD type 1,2 2)basic queries 3)about projects
Viewing 71 - 80 interview questions
See Interview Questions for Similar Jobs
Sql Server Bi DeveloperDatabase SqlAmministratore Del Database Sql ServerSenior Sql Server DbaOntwikkelaar Sql Server EtlSsis DeveloperProgrammer Analyst Sql Server DeveloperTalend Etl DeveloperSql Server DbaSviluppatore Di Database Sql ServerSviluppatore Sql Server EtlSql ServerDatabase Del Server SqlEntry Level Sql Server DbaSql Server ConsultantActimize DeveloperBusiness Intellignece AnalystSsis Ssrs Consultant