Mostly the questions are from UNIX & Abinitio. 1. List the frequently used unix commands 2. How to copy single file into multiple copies 3. How to find the particular string occurrences in a file 4. How to view the content of a zipped file 5. Difference between Incremental Load & Full Load 6. How to find out the user created files in a directory
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
How long working in the ETL technology
Time duration should be less for interview rather 1 hr
Pentaho Scenerio questions
technical stuffs
Indexing, Data cleaning, aggregate functions
database mentioned in the cv
DWH Concepts, ETL Techniques, Performance tuning and others.
Viewing 941 - 950 interview questions