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

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 15135

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

IBM, TCS,

6 15591

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

CTS,

2130

How to do Integration testing in Informatica?

Intelligroup,

5 13047

What is the sheduling the report? What is the need of sheduling the report?

Wipro,

1 4872

Explain about Short cut join?

Wipro,

2 6025

What are the different types of connections?Explain?

Wipro,

1 5183

What are the traps ? What are the disadvantages of traps?

Wipro,

5 10023

What is the difference between the Bo 3.0 and 3.1?

1 9003

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 3877

What is the pragma?

2 5449

What are the Users and User groups?

Wipro,

2 6648

Can Bo generates the Report from the cubical data Explain?

Wipro,

2039

What is the slice and dice?

3 8537

Can anybody tell me what are the tuning problems?

2048

Un-Answered Questions { Data Warehouse }

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1020

Define views in teradata with general syntax.

1038

How to load last n records of file into target table - informatica

1083

What is the size of the cube?

977

What is spool space?

1162

How to create an external dataset with sas code?

1165

What are all the types of report?

1096

What happens when a session fails and you click on recover?

1123

How to find value from a column in a dataset?

2208

How you can fix the truncated data error in datastage?

1797

What is etl process?

944

What is the effect of dls on microstrategy?

1005

what is document design in boxi,have u participate in that

2190

Explain clustering?

982

Which versions are used in the bo dashboard work?

1058

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