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 7057

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

IBM,

1 21502

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

TCS,

2 31600

Difference between Decode and Case?

NIIT, TCS,

1 5159

Difference between Decode and Case?

Polaris, TCS, Wipro,

8 48054

Any Cognos planning Queries Rise

5 11471

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,

2103

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 6524

How to create universe in business objects enterprise 11.5

1 12005

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

3 6524

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

Wipro,

2 26192

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

HCL, IBM, Infosys,

1 8446

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

ME,

8 34206

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

IBM, ME,

6 36859

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

Mannar Company, ME,

2 7946

Un-Answered Questions { Data Warehouse }

What is InformaticaPowerCenter?

1179

What do you understand by the term 'dynamic cube'?

1077

draw informatica architecture 8.6 ?

3933

What is an olap designer?

1018

What is the sas data set? : sas-grid-administration

1036

What is Active Datawarehousing?

1064

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2132

what is the difference between querystudio in reportnet and cognos8

2194

How can you make the sql query to be based on a specific table of your choice?

1104

Have you used Unstructured data?

1377

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1152

How can we handle two sessions in informatica?

1098

What are the types of containers?

1317

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1023

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1071

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