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

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

TCS,

2 8244

How to convert table data into xml file using xml output stage? please explain step by step;

IBM,

2 20184

if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.

2 6856

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

Cap Gemini,

5 9693

What will happen if scheduling a report with a prompt page?

Ness Technologies,

1 5974

How you will do the estimation for a task?

iGate,

1 5216

What is limited local? and the uses?

Ness Technologies,

2 9504

What is model filter and query filter?

Wipro,

2 7238

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

Mind Tree,

2 8296

How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

CTS,

5 9969

what happens when date function has taken as attribute

TCS,

1 4926

what use of surgate key in project

HCL, TCS,

3 7980

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

CTS,

2330

I want to schedule the report as sysdate-1.....how to do

TCS,

2 8023

How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 10130

Un-Answered Questions { Data Warehouse }

I have a few records just I want to store data in to targets cycling way how?

2424

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5129

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1090

What are mapplets?

1333

What are datastage sequences?

1177

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4051

Can you please send me the migration related issues .

2122

Differentiate between datastage and informatica?

1253

Explain which are the olap tools available that are supported by oracle?

1061

Can you define dimension?

1140

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2189

Is it possible to apply themes to microstrategy web? How?

1009

Distinguish between informatica & datastage. Which one would you choose and why?

1060

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

978

Explain how spool space is used.

1122

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