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 is the difference between cognos8 fm and cognos reportnet fm?

1 4822

does query is created for date prompt?

9 11465

what is the use of layout calculation?

4 17232

what is the difference between cascading prompt and drill-thru

4 13144

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

UHG,

2 14012

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

CTS, HCL, IBM, Wipro,

6 32280

What is Merging, Segments and porting in Framwork Manager?

Nike,

3 12307

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Accenture, IBM, TCS,

6 11623

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

TCS,

2383

what is the need of INDEX in datasets?

CitiGroup,

6 13895

tell me about intnx, intcx functions?

CitiGroup,

4 22943

what is Global Symbol table and Local symbol table?

CitiGroup,

4 19766

how to assign a macro value to a variable?

CitiGroup,

8 16652

describe about joins? briefly?

CitiGroup,

2 7213

how to write code for left outer join in SAs using datastep?

CitiGroup,

8 21610

Un-Answered Questions { Data Warehouse }

How to design file watch jobs?

985

What you mean by drill across and what is the difference between drill through, drill across?

1040

What are mapplets? How is it different from a Reusable Transformation?

1107

You can ask about different vector functions. How to use in abinitio graph?

5556

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1291

What are stage variables and constants?

1159

What is defined as Query studio?

1121

How are indexes created after completing the load process?

1662

Explain about a time when you discovered a more efficient way to do a work task?

1167

What are the uses of etl tools?

1147

What is a Framework manager?

1055

what is the basic structure sas administrator? : Sas-administrator

1010

SCD2 will work on only dimension tables as well as fact Table?

1422

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1508

Difference between in process and inter process?

1249

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