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 1429

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

1 1427

How do you improve the performance of the Cognos Analytics report

975

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

1 2067

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

907

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

887

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

754

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

1372

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

1027

Code check-in and check-out commands in AbInitio

4246

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?

936

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

906

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

1026

Runtime behavior of Normalize and Reformat

2628

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.

946

Un-Answered Questions { Data Warehouse }

Name the different sorting methods in datastage.

991

what is sas data set?

1059

What do you mean by drill across?

1078

Repository user profiles

1715

What can you learn from the SAS log when debugging?

1317

What are the types of caches in lookup?

978

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

954

What are the types of containers?

1142

What do think which one is the better joiner or look up?

1143

What is the difference between check point and phase?

1209

when will use SQL override in a lookup transformation?

2229

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2233

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1092

What do you mean by the term data warehousing?

1015

Explain clustering algorithm?

2210

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