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

what is a filter?

4 7263

what is the diffence between render variable & style variable with egs? Plz reply ASAP

TCS,

4 23988

How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 8455

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

Keane India Ltd,

5 20776

What is thin client And thick client..?

2 10585

Which is costliest transformation? costly means occupying more memory?

3 10518

architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

IBM, Infosys,

1 3856

What is AFC? Where we Use AFC in Actuate?

4 9723

What is the server based ranking? and its usage?

2 6659

Is there any comparison available for Cognos Reportnet Vs Crystal reports?

IBM,

3906

How do we drill through from a powerplay cube to reportnet?\

IBM,

2406

Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?

2 5446

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 7633

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 6666

What are the environmental settings for data stage,while working on parellel jobs?

Satyam,

2 8786

Un-Answered Questions { Data Warehouse }

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1580

What is a merge in datastage?

1350

Is it possible to access Redshift compute Nodes directly?

What is a materialized view log?

1046

hi,can you please share with me about,what is reportlimit,report order and how can create and use

5331

How many types of nodes supported by Redshift and what are the functions of nodes?

What are sequencers?

1179

What are the enhanced features in teradata v2r5 and v2r6?

1191

What are public objects?

1100

What is the max core of a component?

1157

Database in use is oracle?

1111

What are situations where snowflake schema is better than star schema when the opposite is true?

1039

How do you use reject loader.

2653

If RDBMS is halted what will you do ?

2222

How to generate sequence numbers using expression transformation?

1152

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