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 a source file is populated?

1115

What are the features of datastage flow designer?

1105

Can you explain tagbatch restructure operator?

1221

What is data partitioning?

1274

Can you explain kafka connector?

1382

What is the sortmerge collector?

1178

What is a datastage job?

1059

How do you import and export data into datastage?

1298

Can you explain players in datastage?

1255

What is usage analysis in datastage?

1365

What is difference between symmetric multiprocessing and massive parallel processing?

1200

What is the project in datastage?

1171

What is ds designer?

1171

What is aggtorec restructure operator?

1532

Can you explain link buffering?

1227

Un-Answered Questions { Data Warehouse }

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2188

What is the session task and command task?

1117

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1411

how do you use tm1 cubes in framework manager?

Highlight a few of the important components of Teradata?

1083

what is null hypothesis? why do you consider that?

2967

Can you define a query subject?

1068

What are the tuning techniques you applied during your last project

2079

What is the use of virtual processor connectivity in teradata?

1096

Tell me about MD5 functions in informatica

983

what is the role of cognos comsultant?what actually it means?pls reply

2377

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1593

What is ods (operation data source)?

1063

what is the Default Source Option For Update Strategy Transformation?

1289

Explain difference between e-r modeling and dimentional modeling?

1040

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