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 7136

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 4696

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

IBM,

2045

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

IBM,

1 4038

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

IBM,

3 6996

what is correlated query?

IBM,

2 5901

what is inline view?

IBM,

1 5348

How can I change reports to another package???

IBM,

3 7196

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

PayPal,

2 15987

what is data driven in update strategy transformation?

HCL, PayPal,

2 17321

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

Ness Technologies,

2 6624

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 5851

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 7939

checkout and checkin in informatica 8.6

TCS,

3 20009

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

TCS,

5 10119

Un-Answered Questions { Data Warehouse }

How do users receive only information that they want?

992

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2354

explain one complex mapping with logic? sales project?

6693

describe the Steps to confiure a Qlogic switch

2397

How to eliminate product joins in a teradata sql query?

1049

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2243

When tpump is used instead of multiload?

1116

What is a local lookup?

1235

What are the different kinds of views available in a datastage director?

1045

what is the use of sas management console? : Sas-di

1109

What is a data processing cycle and what is its significance?

1244

What is a method to debug and test your SAS program?

1388

How do we resolve attribute roles in microstrategy?

1164

How big was your fact table

1817

What is data cleaning?

958

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