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

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

IBM,

2 15464

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

IBM,

9 38928

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

Comsys, IBM,

4 26899

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 59585

What is Join Index in TD and How it works?

BT, CSC, TCS,

6 36271

In merge stage can we update the values?

TCS,

3 12962

Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....

2 7042

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

TCS,

7 46284

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

Nucleus Software,

2 8188

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 8900

How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 29596

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 16976

How i can upload the MainFrame source For Informatica ?

1 9993

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 11871

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

2199

Un-Answered Questions { Data Warehouse }

What is the use of virtual processor connectivity in teradata?

1028

What does the trace option do?

1109

Your i-sever crashed. What will you do?

1068

What is rank metrics in microstrategy?

991

Explain about cumulative Sum or moving sum?

1043

What is a dimension table?

1063

What are constraints and derivations?

1170

What the difference is between a database, a data warehouse and a data mart?

1155

What are data-driven sessions?

1208

Describe the ways in which you can create macro variables? : sas-macro

1067

Can you define framework manager?

1031

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7065

Explain what is metadata reporter?

975

What is the roundrobin collector?

1099

what are the features in cognos8ui

2048

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