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 the conditions needed to improve the performance of informatica aggregator transformation?

1049

Write the program through which the records can be updated?

955

What are the different types of repositories created using informatica?

1078

What are the steps involved after the disk manager passes the request?

1056

Where is teradata rdbms used?

1053

What is the use of teradata system software?

1002

What is the use of stored procedures in teradata?

953

What are the functions involved in shared information architecture?

1039

What can be achieved by using the teradata rdbms?

998

What are the different softwares used with their functions in teradata?

981

What is the function of parser component in teradata?

1053

Write a program to show the parser component used in teradata?

943

What are the components used in smp and massively parallel processing (mpp) machines?

1018

What are the different design perspectives used in teradata?

947

What are the functions performed by bynet?

1000

Un-Answered Questions { Data Warehouse }

What are the types of security?

986

List down some of the real time data-warehousing tools?

930

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2058

How to execute the plsql procedure from the report by clicking with mouse?

1089

What are the tasks that source qualifier perform?

1051

How do we drill through from a powerplay cube to reportnet?\

2317

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2179

What you mean by drill across?

983

How to do unit testing in informatica?

1137

What should I have in mind when building olap solution from scratch?

945

How to read multiple files using a single datastage job if files have the same metadata?

1193

What is workflow manager?

1003

what is unit testing?tell me proceedure

2182

what other sas products have you used and consider yourself proficient in using? : Sas programming

1068

What is meant by a Virtual Disk?

1066

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