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

How to delete duplicate records in a flat file source?

2 8812

What is a configuration management?

1 4261

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

BirlaSoft,

2 6955

What is Drill by? drill through?

CMC, iFlex,

1 10824

How to test a cube?

1 2253

How to create predefined filters in B.O.

TCS,

2 11621

What is the difference between derived table and views? which one gives better performance?

TCS,

2 25064

when will use compatible and incompatible objects?

Business Intelligence Analytics, iGate, TCS,

1 8971

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13903

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 31358

what is the difference between lookupoveride and joiner?

3 7982

what is plsql table?

2 6606

how to declare array in plsql?

1 9551

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18468

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2425

Un-Answered Questions { Data Warehouse }

What is rollup component?

1324

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

How to add default rules in transformer?

1277

Explain in detail about scd type 1 through mapping.

1641

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838

what is document design in boxi,have u participate in that

2289

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

Hi friends, what are the new features in abinito3.0?

2853

What is the difference between business requirement document and use case document.

1073

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2540

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