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 15348

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

IBM,

9 38525

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

Comsys, IBM,

4 26684

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 59067

What is Join Index in TD and How it works?

BT, CSC, TCS,

6 35960

In merge stage can we update the values?

TCS,

3 12795

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 6924

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

TCS,

7 46029

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 8050

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 8700

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

7 29296

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 16534

How i can upload the MainFrame source For Informatica ?

1 9880

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

2 11716

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.

2147

Un-Answered Questions { Data Warehouse }

How do you control the number of observations and/or variables read or written?

1194

What is an expression transformation in informatica?

964

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1092

Explain and compare pros and cons of start schemas?

978

what are the best practices to process the large data sets in sas programming? : Sas-administrator

962

How many data types are there in SAS?

1008

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1910

How can you import tables from a database?

1004

if collect stats but it show low confidence why?

1621

Which are the different editions of informatica powercenter that are available?

972

If your client wanted to customize the null value, how would you do that?

890

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1888

What is the purpose of Dataware Control?

990

What is the difference between where and if statement?

1062

Why redshift Distribution key is used?

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