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 multi-insert?

1047

What are the available primary index types in teradata.

1044

What is bteq utility in teradata?

990

Explain amp in teradata?

1095

How you will check the version of teradata?

1180

List out teradata data types?

1021

How many types of joins are there in teradata?

987

What is the difference between fastload and multiload? Which one is faster?

1241

What is the difference between teradata and oracle?

1038

Why managing the data is important?

1025

What are some commonly used bteq scripts?

1028

Define views in teradata with syntax.

1092

What are some primary characteristics of teradata?

1018

What is the use of having index on table?

1014

How we can covert server job to a parallel job?

1167

Un-Answered Questions { Data Warehouse }

Two default user groups created in the repository are____and_____.

2060

Can you suggest us materials for sdtm mapping?

4459

What is a partition and what are the different types of partition components in abinitio?

1288

Explain the tuning lookup transformation - informatica

1005

What is datastage engine?

1190

What are the different common services in datastage?

1299

Explain what are the advantages data mining over traditional approaches?

1172

Explain target update override in informatica

1135

What is the difference between absolute filtering and standard filtering in microstrategy?

990

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2044

Explain fallback in teradata?

1073

Why do you get spool space errors? How do trouble-shoot them?

1067

What is a ds designer?

1080

Name the different lookup cache(s)?

1247

options available in sequence job to run,validate?

1331

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