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 8122

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

IBM,

2 20056

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 6753

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 9472

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

Ness Technologies,

1 5886

How you will do the estimation for a task?

iGate,

1 5093

What is limited local? and the uses?

Ness Technologies,

2 9375

What is model filter and query filter?

Wipro,

2 7102

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 8165

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

CTS,

5 9721

what happens when date function has taken as attribute

TCS,

1 4823

what use of surgate key in project

HCL, TCS,

3 7822

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,

2283

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

TCS,

2 7898

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 10055

Un-Answered Questions { Data Warehouse }

Explain why fact table is in normal form?

970

What are the stages that are required in data warehousing?

964

What is meta stage?

1180

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

2482

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

965

What interface is used to connect to windows based applications?

1113

What should I have in mind when building olap solution from scratch?

983

What is the difference between informatica 7.0 and 8.0?

1014

Which studio is used to create reports?

1108

What are the different kinds of views available in a datastage director?

1030

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

Which command is used to perform sorting in sas program?

1047

Different circumstance which drives informatica server to expel records?

983

Explain what are the steps to be taken to schedule the report?

1108

Why union transformation is an active transformation?

1047

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