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

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

IBM,

4 7119

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

IBM,

1 4688

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

IBM,

2036

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

IBM,

1 4028

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

IBM,

3 6990

what is correlated query?

IBM,

2 5892

what is inline view?

IBM,

1 5344

How can I change reports to another package???

IBM,

3 7180

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

PayPal,

2 15974

what is data driven in update strategy transformation?

HCL, PayPal,

2 17311

what is system requirement(SR) & business requirement(BR)?

Ness Technologies,

2 6611

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 5846

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

L&T,

2 7924

checkout and checkin in informatica 8.6

TCS,

3 20000

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

TCS,

5 10103

Un-Answered Questions { Data Warehouse }

What is maximum storage capability of SAS?

1435

What are different types of joins that are possible in obiee rpd?

842

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5651

Can tm1 web be set up for load balancing?

Explain the difference between detect alias and detect context?

1113

6500

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1161

In a star schema, are foreign key constraints between facts and dimensions neccessary?

983

Does microstrategy intelligence server support scheduling?

1054

Explain what is difference between query studio and report studio?

996

What is teradata? What are some primary characteristics of teradata?

974

Explain the difference between mapping parameter and mapping variable?

1049

how can we create rank using datastage?what is the meaning of rank?

8799

What is edw?

1204

Explain connectivity between datastage with datasources?

988

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