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?

1066

What are the features of datastage flow designer?

1039

Can you explain tagbatch restructure operator?

1177

What is data partitioning?

1203

Can you explain kafka connector?

1312

What is the sortmerge collector?

1130

What is a datastage job?

1013

How do you import and export data into datastage?

1234

Can you explain players in datastage?

1199

What is usage analysis in datastage?

1307

What is difference between symmetric multiprocessing and massive parallel processing?

1141

What is the project in datastage?

1114

What is ds designer?

1103

What is aggtorec restructure operator?

1452

Can you explain link buffering?

1179

Un-Answered Questions { Data Warehouse }

What is the difference between absolute filtering and standard filtering?

1050

How can you generate reports in informatica?

1029

What is main difference mapplets and mapping?

1193

What are the ways in which macro variables can be created in sas programming?

1103

What are materialized views & where do we use them?

998

How to do unit testing in informatica?

1171

What is the difference between informatica 7.0 and 8.0?

1016

Compare dataset and fileset?

1039

What is the purpose of _character_ and _numeric_?

1068

Approximately what date is represented by the SAS date value of 730?

1217

What security is provided with microstrategy desktop?

967

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

How many steps etl contains?

944

What are session timeout and application timeout?

1018

Why cognos scenario is used?

1067

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