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 4796

does query is created for date prompt?

9 11407

what is the use of layout calculation?

4 17192

what is the difference between cascading prompt and drill-thru

4 13108

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

UHG,

2 13996

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 32225

What is Merging, Segments and porting in Framwork Manager?

Nike,

3 12270

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 11576

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,

2369

what is the need of INDEX in datasets?

CitiGroup,

6 13853

tell me about intnx, intcx functions?

CitiGroup,

4 22904

what is Global Symbol table and Local symbol table?

CitiGroup,

4 19737

how to assign a macro value to a variable?

CitiGroup,

8 16588

describe about joins? briefly?

CitiGroup,

2 7196

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

CitiGroup,

8 21549

Un-Answered Questions { Data Warehouse }

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1378

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1935

What is analytical or analytic mean?

1127

Explain what are the different methods of loading dimension tables?

953

How are the sources and targets definitions imported in informatica designer?

1107

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1862

What is the difference between a scan component and a rollup component?

1191

Explain vproc in teradata?

1000

Explain how you can debug and test your SAS program?

1013

What are the steps to import the two data sources in framework manager?

1048

Explain what task is 98% of the required work of a business analyst?

1103

What are the types of schemas we have in data warehouse and what are the difference between them?

941

What are dimensions?

1059

What is a relationship?

989

What is a surrogate key?

1080

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