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 1501

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

1 1498

How do you improve the performance of the Cognos Analytics report

1036

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

1 2158

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

969

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

932

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

806

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

1406

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

1085

Code check-in and check-out commands in AbInitio

4315

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?

987

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

977

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

1079

Runtime behavior of Normalize and Reformat

2710

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.

989

Un-Answered Questions { Data Warehouse }

What is a joiner transformation and why it is an active one?

1080

What is a bo repository?

1043

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

Which warehouse using in your datawarehouse

2185

Write types of folders present in cognos?

1073

explain in detail about type 3?

1013

What is informatica worklet?

1066

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1083

define data tab?

how would u estimate the size of Aggregator transform data and index cache?

1961

how many modules are there in telecome domain?how to explain the architecture?

2013

What is mean by aggregate aware?

1084

What is session task and command task?

1294

Explain in detail scd type 2 through mapping.

1041

Explain the difference between dw and bi?

1046

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