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 15143

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 15599

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 13053

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

Wipro,

1 4872

Explain about Short cut join?

Wipro,

2 6029

What are the different types of connections?Explain?

Wipro,

1 5188

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

Wipro,

5 10029

What is the difference between the Bo 3.0 and 3.1?

1 9005

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

2 3881

What is the pragma?

2 5453

What are the Users and User groups?

Wipro,

2 6651

Can Bo generates the Report from the cubical data Explain?

Wipro,

2042

What is the slice and dice?

3 8542

Can anybody tell me what are the tuning problems?

2049

Un-Answered Questions { Data Warehouse }

What errors and types of errors you faced in Cognos ReportNet?

4198

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2381

What do the mod and int function do? : Sas programming

1239

What is data transformation manager process?

1167

What are the different types of join operations?

1007

For what purposes have you used sas macros? : sas-macro

1003

What is drill-through?

994

explain about citrix scheduling tool in datastage

2463

What is workflow manager?

1055

How many areas for files does datastage have?

1162

What is the syntax for m_dump in abinitio?

1633

What are roles and groups and benefits of using them?

1060

Explain proc sort?

1129

Explain what are the advantages and disadvantages of reporting directly against the database?

1004

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

989

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