Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 1570

What is Local Cache and how does it help in performance tuning

1 1576

How do you improve the performance of the Cognos Analytics report

1103

What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 2235

What will be the skew for, input file->partition by key-> partition by round robin->output file

1024

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

984

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

865

what is the output when -1 is put in select_expr of FBE?

1445

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1138

Code check-in and check-out commands in AbInitio

4378

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

1036

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

1063

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1130

Runtime behavior of Normalize and Reformat

2762

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

1037

Un-Answered Questions { Data Warehouse }

How many Key we can define in remove duplicate stage?

1447

What is the difference between condition & filter?

1539

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1155

What is a joiner transformation?

1037

What do you mean by Drill down and Drill Up?

1055

After the complete generation of a report who will test the report and who will analyze it?

1044

List any five applications of data warehouse.

991

What are the major challenges you faced while creating the rpd?

918

flat filevalidation in informatica

2202

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2604

What are the advantages of cognos?

1035

what is requery in cognos?

2537

options available in sequence job to run,validate?

1366

Can anybody tell me what are the tuning problems?

2096

What is staging variable?

1153

For More Un-Answered { Data Warehouse } Questions Click Here