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 13261

difference between boxtype and visiable

IBM,

1 7808

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

ABC,

1 9252

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 5579

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 11133

how to call sequential generator in datastage?

IBM,

1 4914

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

IBM,

3129

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 3619

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 4789

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 9889

Explain the scenarios where sequential file stage runs in parallel?

Accenture,

3 15679

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 6775

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

Informatica,

1 11630

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

CNSI, IBM,

1 7828

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

HSBC,

2763

Un-Answered Questions { Data Warehouse }

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2493

Can u generate reports in Informatica?

1099

What are the different formatting types?

1069

How to create a permanent sas data set?

1247

How to stop/start redshift cluster?

What is an object prompt in microstrategy?

1014

Why cognos scenario is used?

1076

What is MPP in Redshift ?

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

994

How to generate the cubes in framework manager?

1052

How do you load only null records into target? Explain through mapping flow.

2036

How many types of hash files are there?

1190

What are vldb properties in microstrategy?

1054

do you need to know if there are any missing values? : Sas programming

1071

What is the use of divide function?

1072

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