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

Difference between cold fusion 5 and cold fusion mx 6?

1001

How can you clear the cache?

1020

What are session timeout and application timeout? Where we have to do this process?

1047

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1009

Which component has onread method and what it is used for?

991

How we are using this function?

1127

Explain the structure of cold fusion?

1050

Database in use is oracle?

1057

Could any one explain me how to create cascading prompts?

1074

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1033

What are session timeout and application timeout?

1026

Can we have multiple application.cfm file in an application?

967

How to know the time taken for particular report execution?

971

Compare cold fusion with other programming languages?

1012

How do we design a universe?

946

Un-Answered Questions { Data Warehouse }

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2731

What is a joiner transformation?

1002

What is workflow manager?

1056

What is the complex report you faced in real time?

2187

What is the size of database for you project?

1598

Explain teradata vs. Redshift?

1034

How analytics process your request when you create your requests?

941

Differentiate between hash file and sequential file?

1081

What is the differences between star and snowflake schemas?

1077

How do you determine the number of sessions?

1068

Explain about round-robi?

1158

What is the difference between drill through and masterdetail reports?

1172

What are the uses of sas?

1280

What do you understand by active and passive transformations?

949

What is the goal of optimizer?

1051

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