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 1506

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

1 1510

How do you improve the performance of the Cognos Analytics report

1039

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

1 2166

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

933

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

810

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

1407

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

1092

Code check-in and check-out commands in AbInitio

4319

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?

990

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

986

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

1082

Runtime behavior of Normalize and Reformat

2718

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.

997

Un-Answered Questions { Data Warehouse }

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2087

What is surrogate key? Where we use it?

998

What are the commands to make a new table, change a table and remove a table in teradata?

1133

How to elaborate powercenter integration service?

1139

How you know when to use a static cache and dynamic cache in lookup transformation?

1857

Have you have ever worked in unix environment and why it is useful in datastage?

1134

How to get the first 100 rows from the flat file into the target?

1210

what is business intelligence? : Sas-bi

1069

How many project sources we can create in metadata?

1096

What are mapplets? How is it different from a Reusable Transformation?

1097

For which purpose Redshift is used for ?

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

what is Active lock explain

2807

What does proc print, and proc contents are used for?

1138

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3873

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