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 are cascading prompts explain with steps

4 24230

what is static filter and dynamic filter

1 11859

when and where we use @varialble function

1 6314

is there any limit for rows and columns in cross tab

4 15222

how to overcome overflow of data in a report

6 21722

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 38907

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

Virtusa,

4 13029

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 6227

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 6491

what is aggregate navigation?

Countrywide, CTS, HCL,

3 26860

what is casual dimension?

CA,

1 7318

how do u implement dense rank in a report?

CTS,

1 4483

Difference between scope of analysis in webi and in deski?

CA,

1 12415

what is maximum scope of analysis --> can we define more than 3 levels?

CTS,

2 10763

how do u implement dense rank in bo reports?

CTS,

2 24660

Un-Answered Questions { Data Warehouse }

what are the different types of fact structures?

1115

Store (and count) non-fact records?

947

What do you understand by overflow errors?

1257

How do you load only null records into target?

1231

what is the main role of FI on business

2125

Explain fact relation?

1029

I have a flat file, want to reverse the contents of the flat file

1140

What are key differences between sql server and amazon redshift?

What all are steps in up gradation of Informatica server?

1056

What is a dimension?

1041

What are all difference between business objects 6.5 and xi r2?

1046

what are the considerations when picking a SAS/STAT procedure?

3387

Explain snowflake schema?

1051

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

2208

Explain what is analytical or analytic mean?

1029

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