regulr sql question and data manipulation
Developer Sql Server Etl Interview Questions
728 developer sql server etl interview questions shared by candidates
What is ETL process
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
Que tipo de problemas has resuelto teniendo en cuenta que tu estás a cargo de un área.
Indexing, Data cleaning, aggregate functions
Slowly changing dimension type 2,Unix commands,Self join queries, joins
Mid level SQL and Informatica Questions
Conocimiento sobre ETL, Incremental Loads, Manejo de errores, Monitoreo, Situaciones de estrés y manejo de más mismas.
Difference between Pandas Dataframe and Numpy Araay?
database mentioned in the cv
Viewing 471 - 480 interview questions