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

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8625

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 10206

differences between service based and product based?

Satyam,

2020

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

Patni,

2 7689

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7246

What is the architecture of ur project? can u explain it? PLz

Patni,

1 3644

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11450

why we use materialized view over view?

Zensar,

1 5309

can session assigned multiple mappings or not?

Zensar,

2 8159

we have to use order by,where,having we to implement sql query

Satyam,

1 5273

what is the default character set in teradata,,?

IBM, TCS,

2 11291

What is SQL Assistence?please eample

IBM,

4 8351

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 4381

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 3107

in performance wise union is past,union all is past

2 5449

Un-Answered Questions { Data Warehouse }

What do you mean by teradata intelliflex?

1113

Can you define materialized view?

1055

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2696

What is mapping debugger?

1022

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1346

What is the basic syntax style in SAS?

1174

Explain the methods to improve performance of a graph?

1111

what is the difference b/w the refresh and buffered data?

2347

which r the connectors used in san?

2189

Separate from an archive server and a powerhouse?

965

How to create repository in abinitio for stand alone system(local nt)?

1236

What are different deliverables according to phases?

3408

How to start a workflow using pmcmd command?

1257

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2915

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