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

differnce between 8.2 and 9.1.3

1 4850

what the use of proc glm

Accenture, C Marc,

1 6904

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

Mphasis,

2 10425

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

Mphasis,

5 9104

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

2129

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

2 8015

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

Syntel,

3 14276

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

Cap Gemini, L&T,

2 8022

I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

IBM,

3 7223

Can we create universe with no cache??

2508

Data WareHousing course in noida

1 3725

Best Data Ware housing training institute in delhi

3 6147

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

Accenture,

2 7290

Is there any target staging area in informatica not staging area

Syntel,

2580

How to fix the etl bugs..Tell me the process?

IBM,

1 3614

Un-Answered Questions { Data Warehouse }

Explain what is the metadata extension?

1037

What is meant by incremental load?

1097

How can I schedule reports in cognos?

1008

define cognos reporting tool?

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

Mention the difference between ‘macros’ and ‘prompt’?

1148

what is epilog tab?

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1130

What is a implicit attribute in microstrategy?

1657

What is the benefit of partitioning a session?

1182

What is etl process? How many steps etl contains?

1034

Explain the methods to improve performance of a graph?

1110

What is the session task and command task?

1060

Can informatica load heterogeneous targets from heterogeneous sources?

1187

explain about various caches available in data integrator? : Sas-di

1052

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