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 Proc glm does?

1091

What is the use of PROC gplot?

1144

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1167

What is the difference between INPUT and INFILE ?

1329

What is Linear Regression?

1172

What is interleaving in SAS?

1119

What is SAS informats?

1111

What does P-value signify about the statistical data?

1368

List out some key concept of SAS

1136

Describe the ways in which you can create macro variables?

1197

What is the use of function Proc summary?

1289

Difference between sum function and using “+” operator?

1164

What is PDV?

1162

What are the new features included in the new version of SAS Programming Language?

1214

What is SAS? What are the functions does it performs?

1201

Un-Answered Questions { Data Warehouse }

What are the different layers in the information server architecture?

1129

Why do we use exception activity in Datastage?

1321

How to select multiple values from type-in prompt?

1062

What is meant by incremental aggregation?

1111

What is meant by incremental load?

1100

Explain what are fact, dimension, and measure?

995

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9148

what is the size of u r source(like file or table)?

2275

What is the difference between agglomerative and divisive hierarchical clustering?

1191

What is dimension modeling?

1094

What is surrogate key? Where we use it? Explain with examples.

1033

How can I test reports in cagonos?

962

What is Cognos script editor?

2563

What are the benefits of data processing according to you?

1216

What is edw?

1204

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