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 difference between infile and input? : Sas-administrator

1208

explain the use of % includes a statement in sas? : Sas-administrator

1052

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

1117

how to generate the test data in sas without input data? : Sas-administrator

1186

explain the key concept of sas? : Sas-administrator

1054

how to debug and test the sas program? : Sas-administrator

1082

what is the basic structure sas administrator? : Sas-administrator

1056

what is sas and what are the functions? : Sas-administrator

1037

what are validation tools that are used in sas? : Sas-administrator

1119

which features do you use to check the data validations and errors? : Sas-administrator

1098

what is program data vector? : Sas-administrator

1126

what are the component of range? : Sas-bi

1153

where to use sas business intelligence? : Sas-bi

1168

what is the primary data source for the wrs? : Sas-bi

1345

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1147

Un-Answered Questions { Data Warehouse }

Explain piconet?

1017

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2053

Explain what are components of report studio?

1182

What is the difference between order and group variable in proc report?

1488

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?

2283

Within a cursor, how would you update fields on the row just fetched?

1127

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1083

how to abort the job its matain duplicates?

2628

What are materialized views & where do we use them?

1081

Explain do we need an etl tool? When do we go for the tools in the market?

1070

What is aggregate cache in aggregator transformation?

1205

In Teradata, how do we Generate Sequence?

1094

What do you mean by blocking transformation?

1122

How the users created differs from rpd/answers/dashboards level?

856

What are the ETL Testing Operations?

1102

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