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 15556

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

IBM,

9 39307

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

Comsys, IBM,

4 27116

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 60002

What is Join Index in TD and How it works?

BT, CSC, TCS,

6 36528

In merge stage can we update the values?

TCS,

3 13115

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 7145

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

TCS,

7 46508

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 8299

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 9043

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

7 29850

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 17290

How i can upload the MainFrame source For Informatica ?

1 10074

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

2 11992

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.

2250

Un-Answered Questions { Data Warehouse }

Explain the difference between rolap and molap?

1024

What is transformation metric in microstrategy?

1073

tell me the rules and responsblites in our project(my project is development)

1984

what is the difference between == and eq in UNIX shell scripting?

1563

What does PROC print, and PROC contents do?

1282

What is the difference between %local and %global? : sas-macro

1243

What is the 4 + 1 view model as it relates to system modeling?

1099

What is a rollup component?

1175

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1105

What is the difference between a primary and secondary actor in use case modeling?

1135

Where do the datastage jobs get stored?

1272

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

1027

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

982

Do you need to know if there are any missing values?

1086

What are the popular informatica products?

1060

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