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 sas data set?

1062

How will you generate test data with no input data?

1117

What is the difference between input and infile statement?

1119

What is the difference between reading data from an external file and reading data from an existing data set?

1127

Describe the ways in which you can create a macro variable?

1042

Mention the category in which sas informats are placed?

982

How substr function works in sas?

1161

What is the difference between informat and format statement?

1 1576

How do dates work in sas?

1080

What is the difference between the proc sql and data step?

1116

What is the good sas programming practices for processing large data sets?

1066

What is the difference between where and if statement?

1074

What are the different types of sas functions?

1196

Mention common programming errors committed in sas ?

1070

What is by-group processing?

953

Un-Answered Questions { Data Warehouse }

Code check-in and check-out commands in AbInitio

4253

How many codd's rules are satisfied by teradata database?

1055

What is called partitioned primary index (ppi)?

965

How to generate cubes in cognos?

911

what is the difference between cubes and package in cognos

4893

Mention few test cases and explain them?

895

How online/offline mode impact development and delpoyment?

772

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2177

How to create a repository in abinitio for stand-alone system(local nt)?

1070

How sas treats the dsd delimiters?

1164

Explain the characteristics of cognos?

999

what is mean by complex business rule ?

2121

Describe crosslist option in tables statement?

1180

Explain what are the various transformation available?

980

State the difference between an operational datastage and a data warehouse?

1068

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