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 4998

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,

3255

how to remove staging area

1 5608

1. Differences between Merge and Union In Cognos?

Wipro,

2651

2. What is With Clause In Cognos?

Wipro,

2 14283

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

CTD, Wipro,

3 23045

What are different events in Report studio?

Wipro,

2271

Create 12 columns for months by writing single case statement?

Wipro,

1 5260

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

Wipro,

1 8201

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

Wipro,

2 10388

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

Satyam,

5 16470

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

Patni,

1 8635

Difference between Express authoring mode and Professional authoring mode?

Wipro,

2 7834

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

Cognizant, CTS,

1 4558

Can we install cognos on windows 7?

4 9070

Un-Answered Questions { Data Warehouse }

Can you define confirmed dimension?

1089

What’s the use AWS redshift cluster Service?

What are the types of hashed files in data stage

1110

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1478

Explain sessions?

1075

Name the types of report?

963

what actually happens when bulk load mode starts?

If RDBMS is halted what will you do ?

2176

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1179

What are all the types of hierarchies?

1139

where is the cache (lookup, index) created and how can you see it.

2017

------------- How to identify the Revenue Column in Report?

2394

What are initial page components of Cognos connection?

1016

------------ Diff b/w MemberCaption and MemberDescription?

2323

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