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 4993

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,

3254

how to remove staging area

1 5607

1. Differences between Merge and Union In Cognos?

Wipro,

2645

2. What is With Clause In Cognos?

Wipro,

2 14278

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

CTD, Wipro,

3 23041

What are different events in Report studio?

Wipro,

2265

Create 12 columns for months by writing single case statement?

Wipro,

1 5257

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

Wipro,

1 8198

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

Wipro,

2 10384

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

Satyam,

5 16463

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

Patni,

1 8628

Difference between Express authoring mode and Professional authoring mode?

Wipro,

2 7830

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

Cognizant, CTS,

1 4554

Can we install cognos on windows 7?

4 9061

Un-Answered Questions { Data Warehouse }

How would you get two images on microstrategy login page?

991

Explain what is the metadata extension?

1044

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1966

What are the steps involved after the disk manager passes the request?

1123

Explain which columns go to the fact table and which columns go the dimension table?

930

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

What are the advantages of informatica?

1014

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

1073

How does a sorter cache works?

1075

Where do we use mapping variables in informatica?

1074

What is called materialized view?

1084

How a server job can be converted to a parallel job?

1096

How to a create header dynamically in a crosstab report in cognos 8.1?

2441

What is object stores?

995

What are the functions which are used for character handling functions?

1147

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