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 1459

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

1 1458

How do you improve the performance of the Cognos Analytics report

994

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

1 2100

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

930

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

904

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

768

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

1385

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

1047

Code check-in and check-out commands in AbInitio

4270

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?

950

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

922

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

1044

Runtime behavior of Normalize and Reformat

2656

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.

964

Un-Answered Questions { Data Warehouse }

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2523

------------ Diff b/w MemberCaption and MemberDescription?

2288

Explain the term 'columns' related to relational database management system?

1024

What is cost benefit analysis (cba)?

952

Did you write stored procedures in teradata?

1087

How to load the time dimension?

977

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1604

How many Key we can define in remove duplicate stage?

1338

How to RD using transformer?

1379

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1349

what are the different types of fact structures?

1048

What is difference between model & package?

1003

What is difference between join, merge and lookup stage?

1062

During the running session, output files are created by informatica server. Enlist few of them.

950

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2398

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