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

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 7612

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 6131

How to use value prompt and drag it on to report editor

Infosys,

3 12422

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.

Target, TCS,

6 13731

what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.

2 14785

in which companies SAS openings are there? List of companies using SAS technology.

MIR-IFCR, TCS,

14 56162

what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

IBM,

2 7388

can any body tell me how to create Hyperlinks in BO XI R2?

2 10976

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 4572

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

Accenture, Patni,

1 5077

how to design the change capture stage in(data stage parallel jobs) type 2

IBM,

2 49414

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 4428

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 19659

What is a Complex report and explain?

IBM, Satyam,

4 11036

How a Referential integrity is handled in Teradata?

5 23695

Un-Answered Questions { Data Warehouse }

Terminate Activity

1343

Explain what are the advantages and disadvantages of reporting directly against the database?

1061

what are factless facts? And in which scenario will you use such kinds of fact tables.

1863

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2266

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1147

How is MLOAD Client System restarted after execution?

1207

what is data integration? : Sas-di

1169

Differences between where and if statement?

1159

Does datastage support slowly changing dimensions ?

1160

In document how to create metrics?

1046

What is the opening step in basic teradata query script?

1094

what does the run statement do? : Sas programming

1102

explan ur project architecture?

2129

What is analytical or analytic mean?

1192

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097

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