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 8148

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

IBM,

2 20073

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 6767

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 9502

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

Ness Technologies,

1 5898

How you will do the estimation for a task?

iGate,

1 5110

What is limited local? and the uses?

Ness Technologies,

2 9404

What is model filter and query filter?

Wipro,

2 7133

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 8185

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

CTS,

5 9764

what happens when date function has taken as attribute

TCS,

1 4842

what use of surgate key in project

HCL, TCS,

3 7845

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,

2290

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

TCS,

2 7926

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 10075

Un-Answered Questions { Data Warehouse }

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1016

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1039

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1068

What is the method of removing duplicates, without the remove duplicate stage?

1039

how would u estimate the size of Aggregator transform data and index cache?

1974

Why we use repository connectivity?

990

Are you sensitive to code walk-throughs peer review or QC review?

3156

What are global filter and how they differ from column filter?

977

Explain about power designer data modeling software?

863

Is multi insert ansi standard?

2220

How can the user determine the object id of an object?

950

Explain what are the different versions of informatica?

1112

What are vldb properties?

1032

What are SAS/ACCESS and SAS/CONNECT?

1156

Explain what are conformed dimensions?

1097

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