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?

1094

What are the available primary index types in teradata.

1087

What is bteq utility in teradata?

1029

Explain amp in teradata?

1166

How you will check the version of teradata?

1235

List out teradata data types?

1070

How many types of joins are there in teradata?

1029

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

1306

What is the difference between teradata and oracle?

1076

Why managing the data is important?

1063

What are some commonly used bteq scripts?

1068

Define views in teradata with syntax.

1141

What are some primary characteristics of teradata?

1065

What is the use of having index on table?

1047

How we can covert server job to a parallel job?

1279

Un-Answered Questions { Data Warehouse }

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

990

What are the tasks that can be performed using sq?

1148

What are the types of hashed files in data stage

1148

what is the difference between nodup and nodupkey options? : Sas programming

1278

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2238

What is the definition of cube in datawarehousing?

1053

What are aggregate tables? How do you design them using teradata?

1233

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1100

Explain the main difference between the sas procedures and functions? : Sas-administrator

1126

What are the differences between star and snowflake schema?

1195

Explain difference between e-r modeling and dimentional modeling?

1042

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2087

Is hadoop a etl tool?

1011

What is the difference between a primary and secondary actor in use case modeling?

1137

What tools would you use for that?

1172

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