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 do u tune queries?

1 6604

what is metadata?

6 10227

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 11952

what is the difference between onsite & client site?

1 10464

what is the difference between the SAS v8 and SAS v9?

TCS,

7 25396

what is the SAS/ACCESS and SAS/CONNECT?

Accenture, iFlex, TCS,

9 35460

Can we replace a dataset into view?

CliniRx,

6 12556

Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?

HCL,

1 4067

how do you read binary data in sas?

Satyam,

3 15515

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

Infosys, TCS,

2 18194

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 13171

how do u identify a macro variable

5 14180

How could you generate test data with no input data?

Quintiles,

6 16770

· What are some good SAS programming practices for processing very large data sets?

Quintiles,

6 20787

what other SAS features do you use for error trapping and data validation?

Quintiles,

3 8500

Un-Answered Questions { Data Warehouse }

What are the statements in proc sql?

1112

What is the difference between check point and phase?

1322

What is called data cleaning?

1251

Explain by-group processing?

1006

Explain fact table?

1063

What is the function of Stop statement in a SAS Program?

1163

What is the use of having index on table?

1014

What do you mean by teradata sql assistant?

1074

what are some differences between proc summary and proc means? : Sas programming

1147

Which command is used to save logs in the external file?

1115

explain about various caches available in data integrator? : Sas-di

1073

What is model filter?

1234

How to test a cube?

2207

What are snapshots?

992

What is the difference between drill through, drill across?

1098

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