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

What is the use of Cognos scenario?

1243

What are all types of Batches?

1083

What do you mean by Drill down and Drill Up?

1057

How can bottlenecks be identified?

1067

What are the newly developed features of Teradata?

1092

Comment whether bottleneck is an error or not.

1230

Highlight all the modes that are present under Confidence Level.

1017

What is TPD?

1426

Highlight a few of the important components of Teradata?

1083

How do you define Teradata?

1087

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1267

Name the five phases that come under MultiLoad Utility.

1032

How can we check the version of Teradata that we are using currently?

1114

What are the primary characteristics of the Teradata.

1251

How is MLOAD Teradata Server restarted after execution?

1348

Un-Answered Questions { Data Warehouse }

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2191

What is the difference between informatics 7x and 8x and what is latest version?

1143

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2052

What is the difference between hashfile and sequential file?

1322

what is the difference between the report filter and report limit?

1027

What is the SAS data set?

1185

State the difference between INFORMAT and FORMAT ?

1156

Do we need an ETL tool? When do we go for the tools in the market?

1038

What are the different options associated with dsjob command?

1493

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1228

What is option by which we can run all the sessions in a batch simultaneously?

1204

Can anyone tell me the new features in Informatica 9 Version?

2221

How are the sources and targets definitions imported in informatica designer?

1176

What are the differences between proc means and proc summary?

1203

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