Scenario based: Delete duplicates rows from that target table without having a primary key
Developer Sql Server Etl Interview Questions
728 developer sql server etl interview questions shared by candidates
what do you know about the SCD(Slowly changing dimension)?
They asked just one technical question that how would you add a Header , Detail and Footer to a target flat file.. ? Would you require 3 different target files to do that or you can do it in one? HOW?
all of the questions are the easiest questions I have met ever, some thing like what is SSIS, what is the component of SSIS, what is the data profile... And I guess they are expecting the exact answer like Interview-answer books.
Previous project experience and difficulties faced in that
About transformations and SQL queries
To solve some hypothetical data questions on a whiteboard
Describe different ytpes of SCD
Difference between ddl and dml command
Mostly general questions on Informatica, Data warehousing and SQL
Viewing 131 - 140 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