1. write a SQL query to identify the employee with second largest salary 2. write a query to remove duplicate records in a table 3. explain SCD type 2 mapping
Informatica Analist Interview Questions
1,186 informatica analist interview questions shared by candidates
1. dataware housing concepts : difference between OLTP/OLAP ,difference between Fact/Dim 2. Informatica : difference between lookup/Joiner,types of tranformations , more on lookup and file loading 3. Database : how to delete dups from table, Cross join function , difference between delete/truncate ,difference between intersect/inner join, query approch 4. Informatica scenarios : read bulls raider for the same
questions on my projects
I honestly don't remember any.
Quais são as suas experiências anteriores?
They asked me how my background matched what they were looking for in this role.
Preguntas relacionadas al perfil cómo, años de experiencia, proyectos en los que participaste, dónde trabajaste anteriormente, áreas de oportunidad, etc...
What is your background? Why did you major in x/y/z?
What type of student were you in university?
All basic infotmatica question performance tuning SQL queries SCD
Viewing 791 - 800 interview questions
See Interview Questions for Similar Jobs
Applicatie AnalistInformatica OntwikkelaarSas Bi-ontwikkelaarInformatiesystemen AnalistEpische Bruggenanalist Met Klaverblad En BruggencertificeringIct Pl Sql Ontwikkelaar Data AnalistBi Cognos-beheerderManager GegevensanalyseInformatietechnologie-analistInformatieanalistSsis-ontwikkelaarSas Programmeur AnalistDelphi OntwikkelaarApplicatiesysteemanalistManagement Informatie Systeem Mis AnalistApp-ontwikkelaarInformatica Stagiair(e)Statistisch Programmeur-analist