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 type of transformation is not supported by mapplets?

CTS,

4 15636

Tell me the Top 10 features of oracle that supports datawarehousing.

CTS, IBM,

2 8076

How will you update the row without using update statergy?

CTS,

10 14968

How will you update the first four rows and insert next four rows in a mapping?

CTS,

5 10883

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

Wipro,

1 8296

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 4038

how to join the 2 different table with different columns in informatica?

Accenture,

5 23740

How to load the source table into flat file target(with columns) in informatica?

Accenture,

4 17712

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

Hexaware,

2 6545

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20682

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 11806

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 5548

What is drill across ? can anybody explain me in detail?

1 5348

How we can resolve the loops by using the Aggrigate Awareness?

Hexaware,

1 3480

How to create Index to the table in the universe designer and how it improves the Query performence

2553

Un-Answered Questions { Data Warehouse }

What is the use of dimensional modeling in data warehousing?

988

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2378

How many ways a relational source definition can be updated and what are they?

1019

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2423

What are the different types of lookups in datastage?

1059

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1024

How do you add a number to a macro variable? : sas-macro

1015

Explain the code page compatibility?

1074

What is node? How many nodes and amps used in your previous project?

1111

what is online view?

1944

What is a table alias in obiee 11g? Where and how will you create it?

1016

how does sas handle missing values in sort order? : Sas programming

927

Where the datastage stored his repository?

1089

----------------------What are the User Securities?

1859

How to limit decimal places for the variable using proc means?

1083

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