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

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

Wipro,

6 13268

difference between boxtype and visiable

IBM,

1 7812

Need Informatica Power Center 9.1 free download(for all windows version)

ABC,

1 9257

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

Wipro,

1 5583

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 11137

how to call sequential generator in datastage?

IBM,

1 4918

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

IBM,

3134

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 3621

Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata

Cognizant,

1 4792

i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance

IBM,

2 9897

Explain the scenarios where sequential file stage runs in parallel?

Accenture,

3 15687

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

Accenture,

1 6785

What is Collect performance data in informatica and what is the use of it.

Informatica,

1 11635

where we use page break and page set. with example?

CNSI, IBM,

1 7828

What are the table names in oracle database...?

HSBC,

2767

Un-Answered Questions { Data Warehouse }

what is the difference between cubes and package in cognos

4964

What are the steps to do to use alerts in bo?

1411

How can you generate reports in informatica?

1045

Can Bo generates the Report from the cubical data Explain?

2042

Why do you think data processing is important?

1144

What information is shared by the application across microstrategy web nodes?

1061

What is smart metric?

977

Explain informatica architecture - version 8 / 9

1104

What is dimensional table?

1079

What is the difference in the way microstrategy handles custom group and consolidations?

1004

What is the reusable transformation?

1060

How would you include common or reuse to be processed along with your statements?

2393

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

2024

Enlist the various types of transformations.

1073

How would you get two images on microstrategy login page?

996

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