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

I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?

2 6949

What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

IBM,

1 21415

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

TCS,

2 31453

Difference between Decode and Case?

NIIT, TCS,

1 5095

Difference between Decode and Case?

Polaris, TCS, Wipro,

8 47811

Any Cognos planning Queries Rise

5 11287

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

TCS,

2069

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 6458

How to create universe in business objects enterprise 11.5

1 11908

Can anyone plz tell me How to create universe in business objects enterprise 11.5

3 6403

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

Wipro,

2 26076

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

HCL, IBM, Infosys,

1 8344

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

ME,

8 33966

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

IBM, ME,

6 36690

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

Mannar Company, ME,

2 7851

Un-Answered Questions { Data Warehouse }

What is dimension modeling?

1097

list out all the transformations which use cache?

1191

Have you ever used the SAS Debugger?

1769

What is the 4 + 1 view model as it relates to system modeling?

1055

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

3467

What are aggregate tables? How do you design them using teradata?

1180

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2596

Explain constraint based loading in informatica

1104

What is an er diagram?

1059

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1016

what are the types of interactive display types? : Sas-bi

1103

Explain differences between star and snowflake schemas?

1168

When do we analyze the tables? How do we do it?

968

-----------With out using DrillThrough how to do Reports?

2060

How to load a Dimension ? and how to load a fact table?

1427

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