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

Explain briefly scd type2 in datastage7.5x2(parallel)

IBM,

1 6034

Order of Evaluation of Parameters

2 13330

How to convert RGB Value to Hexadecimal values in datastage?

3998

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 9099

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 11043

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 9031

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 5551

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

US Technology,

6 9683

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 6674

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 7131

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 7891

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 6190

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 7556

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 6467

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2138

Un-Answered Questions { Data Warehouse }

What is a staging area? What is the purpose of a staging area?

885

Explain entity, attribute and relationship in datastage?

1104

What are the different types of olap? Give an example?

1057

what is null hypothesis? why do you consider that?

2903

what is the difference steps for data modeling?

2140

Database in use is oracle?

1053

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2363

what will be the contents for a functional requirements specifications

2355

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1062

any difficulitis have you phase while creating bo reports and how did u solve it

3452

What do you mean by filter transformation?

953

client know skid info?

2083

What are the various ways of incorporating security in microstrategy?

998

What is a Datastore in Cognos?

1289

Different sorts of metadata that stores in the storage facility?

1012

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