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 15462

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

IBM,

9 38921

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

Comsys, IBM,

4 26897

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 59576

What is Join Index in TD and How it works?

BT, CSC, TCS,

6 36267

In merge stage can we update the values?

TCS,

3 12959

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 46280

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 8186

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 29589

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 16971

How i can upload the MainFrame source For Informatica ?

1 9990

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

2 11867

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 are the considerations regarding performance kept in mind while setting up cognos?

964

what is the basic structure sas administrator? : Sas-administrator

1005

What is a staging area? Do we need it? What is the purpose of a staging area?

996

How is union transformation utilized?

1009

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1039

What is the difference between set functions and filter function in dimensional data?

2910

What can we do with datastage director?

1236

Explain system call error?

1009

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1179

What are teradata utilities?

1109

How to do performance tunning of reports?

2314

define prolog tab?

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1079

What is maximum storage capability of SAS?

1423

What is difference between primary key and unique key constraints?

988

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