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 7065

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

IBM,

1 21505

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

TCS,

2 31615

Difference between Decode and Case?

NIIT, TCS,

1 5169

Difference between Decode and Case?

Polaris, TCS, Wipro,

8 48097

Any Cognos planning Queries Rise

5 11497

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,

2105

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 6534

How to create universe in business objects enterprise 11.5

1 12018

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

3 6542

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

Wipro,

2 26207

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

HCL, IBM, Infosys,

1 8454

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

ME,

8 34253

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

IBM, ME,

6 36879

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

Mannar Company, ME,

2 7955

Un-Answered Questions { Data Warehouse }

What is the difference between the public object&schema object?

1144

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

2147

What is broadcasting and replicate?

1233

what is 'reconsideration error' and how can i respond to this error and how to debug this

2677

How to convert RGB Value to Hexadecimal values in datastage?

4072

What is level based metrics.how will you create it?

947

How one source columns or rows to be loaded in to two different tables?

1189

What is real-time datawarehousing?

1082

Explain what are the various etl tools in the market?

1003

What are vldb properties?

1074

what is program data vector? : Sas-administrator

1126

What are the 3 components in sas programming?

1252

Define report item?

1262

What is the function of surrogate key in data warehousing?

1145

Enlist various types of routines in datastage.

1339

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