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

If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com

EDS,

1 4985

1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?

Wipro,

3250

how to remove staging area

1 5601

1. Differences between Merge and Union In Cognos?

Wipro,

2640

2. What is With Clause In Cognos?

Wipro,

2 14270

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

CTD, Wipro,

3 23025

What are different events in Report studio?

Wipro,

2264

Create 12 columns for months by writing single case statement?

Wipro,

1 5249

What is Tool Tip? and how to create in report studio?

Wipro,

1 8195

How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?

Wipro,

2 10375

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

Satyam,

5 16444

Are facts same as metrics and dimensions same as measures? If not , please tell the difference?

Patni,

1 8624

Difference between Express authoring mode and Professional authoring mode?

Wipro,

2 7820

When we are using Dynamic Cache,which options we will select in session level?

Cognizant, CTS,

1 4541

Can we install cognos on windows 7?

4 9049

Un-Answered Questions { Data Warehouse }

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

tell me about your project functionality

2341

What’s the use AWS redshift cluster Service?

How to increase performance without changing anything in mapping.( In prod)

1264

What are the primary characteristics of the Teradata.

1154

How do you ensure simultaneous releases across multiple operating systems?

970

Explain the key challenges that you face while performing etl testing.

1009

is it possible to index the data in cache of lkp transformation ?

2029

What does sleep function does in fast load?

1138

How much data hold in one universe.

994

What is the function of cognos dispatcher?

1214

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

900

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1004

Explain can a dimension table contains numeric values?

967

How do we resolve attribute roles in microstrategy?

1151

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