Star schema , snow flakes scheme, joins, transformations.
Informatica Etl Entwickler Interview Questions
126 informatica etl entwickler interview questions shared by candidates
What version of Informatica power center tool in used in your project.
Questions on data modelling, workflow and scheduling
Asked about informatica Basics few scenario based questions and db questions.To describe about previous project and your role there.
Scenarios. Definition. SQL related. Informatica related.
Technical questions were tough but worth to give it , they have good process of selection
Q: How do you see yourself in next 5 years?
operating systems kernel mode and user mode
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
Remove duplicates in SQL, SCD type 2 flow, Dynamic lookup, Department wise highest salary query in SQL, How to consider list of files in Informatica PC
Viewing 61 - 70 interview questions
See Interview Questions for Similar Jobs
Leitender Informatica Etl EntwicklerObiee BeraterObiee Etl EntwicklerBi-entwicklerEtl EntwicklerObiee 11g EntwicklerAdministrator Für GeschäftsobjekteSap-business-objekte-entwicklerBi-managerData Warehouse Etl EntwicklerData-warehouse-analystSap Bi Bo BeraterSenior Informatica EntwicklerSql EntwicklerSenior Etl-entwicklerSenior Data Warehouse-architektSap Bw EntwicklerBusiness-objekte Entwickler Datenanalytiker