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

How can you connect eme to abinitio server?

1 4248

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

1223

What information does a .dbc file extension provides to connect to the database?

1185

What is sandbox?

1152

Explain how you can run a graph infinitely in ab initio?

1070

What is the difference between partitioning with key / hash and round robin?

1277

What is de-partition in abinitio?

1329

What is rollup component?

1185

What is sort component in abinitio?

1179

What is a rollup component? Explain about it.

1131

How to add default rules in transformer?

1174

Define query studio?

960

What is main difference mapplets and mapping?

1114

Define metrics studio?

985

What are the types of studio?

1108

Un-Answered Questions { Data Warehouse }

Do you need to know if there are any missing values?

1004

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

1027

Which date function advances a date, time or datetime value by a given interval?

1092

Explain normalization?

1064

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1861

Performance tuning in UNIX for informatica mappings?

2523

Define different types of attributes in microstrategy desktop?

1169

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

892

What are the data types in sas?

1012

How to generate cubes in cognos?

913

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

8969

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2467

Explain what is SAS informats?

1051

can you change the location of the obiee repository?

792

Why is chameleon method used in data warehouse?

1115

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