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 15357

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 15827

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,

2175

How to do Integration testing in Informatica?

Intelligroup,

5 13251

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

Wipro,

1 4959

Explain about Short cut join?

Wipro,

2 6129

What are the different types of connections?Explain?

Wipro,

1 5304

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

Wipro,

5 10227

What is the difference between the Bo 3.0 and 3.1?

1 9104

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

2 3984

What is the pragma?

2 5525

What are the Users and User groups?

Wipro,

2 6751

Can Bo generates the Report from the cubical data Explain?

Wipro,

2087

What is the slice and dice?

3 8692

Can anybody tell me what are the tuning problems?

2098

Un-Answered Questions { Data Warehouse }

What is the advantages data mining over traditional approaches?

1026

What is Additive function?

2085

What are all the types of indexes in Cognos?

1306

Explain pmcmd command usage in informatica

1191

What are partition points?

1144

What is difference between user and database in teradata?

1121

what are the deliverables?in your project?

2200

what is star schema? : Sas-di

1190

what is factor analysis? : Sas-administrator

1148

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2800

Tell e how how dealt with..

2315

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1939

Performance tuning( what you did in performance tuning)

2059

Why update strategy and union transformations are active?

1101

What are the available join types in teradata?

1119

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