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 4890

does query is created for date prompt?

9 11723

what is the use of layout calculation?

4 17404

what is the difference between cascading prompt and drill-thru

4 13308

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

UHG,

2 14126

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 32552

What is Merging, Segments and porting in Framwork Manager?

Nike,

3 12416

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 11867

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,

1 2436

what is the need of INDEX in datasets?

CitiGroup,

6 14126

tell me about intnx, intcx functions?

CitiGroup,

4 23144

what is Global Symbol table and Local symbol table?

CitiGroup,

4 19969

how to assign a macro value to a variable?

CitiGroup,

8 16906

describe about joins? briefly?

CitiGroup,

2 7332

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

CitiGroup,

8 21819

Un-Answered Questions { Data Warehouse }

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1189

Explain scd type 3 through mapping.

1065

Hi, If anyone has base SAS certification dumps, please share.

1932

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

What is dimensional table?

1145

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

Write the unconnected lookup syntax and how to return more than one column.

1164

What r the names of the reports that you prepared?

1023

Explain how to generate iqd file from framework manager?

1010

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099

How do you remove duplicate records in informatica? And how many ways are there to do it?

1224

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

1214

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

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