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 38926

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

Comsys, IBM,

4 26898

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 59582

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 12961

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 46283

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 8187

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 29593

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 16975

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 are templates in which way it is help full?

996

What is the information present in the cognos configuration file?

958

Do you think effective communication is necessary for data processing?

1219

what is dynamic insert?

2201

Define ds designer?

1278

write a query to retrieve the latest records from the table sorted by version(scd)

1068

what is enterprise guide? What is the use of it? : Sas programming

1021

What is dynamic aggregation in microstrategy?

973

What is the difference between informatica and datastage?

1227

What are symget and symput? : sas-macro

1315

What is meant by Teradata Gateway?

1058

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1829

What is the sequence generator transformation in informatica?

1184

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106

what is sas enterprise intelligence architecture? : Sas-bi

977

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