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

We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

907

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

942

Where we use afc in actuate?

1028

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?

1046

What is data stream and data adapter is it same are different?

983

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

977

What is afc?

981

What is data stream and data adapter is it same are different? Explain?

973

What is static and local variable?

1038

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

What is surrogate key? Where we use it explain with example?

931

Explain can a dimension table contains numeric values?

971

What is crass reference table?

1059

What is a fact, dimension, measure?

1210

Explain difference between e-r modeling and dimentional modeling?

994

Un-Answered Questions { Data Warehouse }

What is dynamic cache?

1039

Enlist the functions performed by sas.

1128

Define Data Warehousing?

1153

What are pdv and it functions?

1151

What is Redshift Enhanced VPC Routing?

What are universe requirements?

1051

What is the Process to creating lookup transformation in informatica

1046

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

What are materialized views & where do we use them?

1003

Write the advantages of partitioning a session?

1282

What is the main difference between star and snowflake star schema? Which one is better and why?

1035

faq's on cognos

4049

How to load last n records of file into target table - informatica

1083

where to store informatica rejected data? How to extract the informatica rejected data?

1007

how to load the data to fact table?

2705

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