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

Separate from an archive server and a powerhouse?

1011

Make a note of the quantity vaults made in informatica?

1046

How is union transformation utilized?

1063

What is meant by incremental aggregation?

1187

Different qualification between a related rotate toward the sky and isolates look upward?

1043

Clarify the aggregator change?

1085

What is joiner change?

1194

What is lookup change?

1114

How might one distinguish in the case of mapping is right or not without associating session?

1197

What does cheating measurement mean?

1108

Separate from a database, an information bazaar, and an information stockroom?

1137

What is depict expression change?

1201

What is intricate mapping?

1322

Clarify the utilization of aggregator cache record?

1045

What does refresh system mean, and what are its distinctive choice?

1276

Un-Answered Questions { Data Warehouse }

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2391

What is the difference between teradata and basic rdbms?

1074

Can you define a catalog and types of catalogs in cognos?

1102

Why are meta service important then other services?

1021

what is xcelsius architecture?

4645

What is meant by Teradata Gateway?

1115

how u will determine the performence tune will occur either in report or system

2185

Mention few power centre client applications with their basic purpose?

1002

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2080

What a datastage macro?

1104

What is defined as Query studio?

1177

What is factless fact tables?

1292

Have you worked with/created Parameter file

1716

Explain fallback in teradata?

1105

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2319

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