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

Difference between sequential file and data set?

1271

What is a merge in datastage?

1354

How to perform incremental load in datastage?

1272

What is the flow of loading data into fact & dimensional tables?

1118

What are the functionalities of link partitioner?

1080

What is the purpose of pivot stage and types of containers in datastage

1086

How can we improve performance of data stage jobs?

1080

What are system variables and sequencers in datastage

1194

Difference between data warehousing and olap?

1155

What is the difference between operational data stage (ods) and data warehouse?

1300

What are the types of containers in datastage?

1233

Explain entity, attribute and relationship in datastage?

1167

Difference between in process and inter process?

1318

What are stage variables and constants?

1205

What are the components of datastage?

1187

Un-Answered Questions { Data Warehouse }

explain the methodology of Data Warehousing?(Polaries)

2090

What is data analytics in simple terms?

1274

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153

What information is shared by the application across microstrategy web nodes?

1098

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

1279

What is meta stage?

1249

What is difference between join, merge and lookup stage?

1158

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2119

how can you put a "trace" in your program? : Sas programming

1118

Explain the architecture of amazon redshift?

If your client wanted to customize the null value, how would you do that?

1076

What is incremintal loading?

1205

List some pros and cons of amazon redshift?

What is parallel processing in informatica?

1803

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