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 is the enterprise class platform architecture of cognos 8?

990

What are the services provided in cognos 8?

985

Explain the different types of views used in cognos.

908

What are the main services provided by application tier?

945

What are the roles defined by cognos platform?

1095

What is the importance of having monitor service in cognos?

998

What are the considerations regarding performance kept in mind while setting up cognos?

932

What are the components used in web tier?

947

What is the difference between low affinity and high affinity connections?

982

What are the different types of important services used in cognos?

978

What is the function of cognos dispatcher?

1166

What is the use of powerplay web viewer in cognos?

1046

What are the different kinds of panes included in cognos?

1012

Why is auto-regression used in forecasting used on cognos platform?

967

What is a folder? Difference types of stages?

1123

Un-Answered Questions { Data Warehouse }

What is a fantrap in business objects?

1115

How can you differentiate between powercenter and power map?

1035

what is unit testing?tell me proceedure

2181

Explain adhoc reports?

883

What are data-driven sessions?

1158

How we can decided drilling options for an attribute?

936

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

977

What is meant by Reportstudio shortcut?

2138

Describe routines in datastage? Enlist various types of routines.

965

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2824

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2944

Explain object variable error?

945

Triggers,VIEW,Procedures

1188

What is a folder? Difference types of stages?

1123

Name the types of gateway?

976

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