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

How to load time dimension?

Ford,

1 15757

In update strategy target table or flat file which gives more performance ? why?

7 26281

How do you create single lookup transformation using multiple tables?

TCS,

6 44614

Why touse stored procedure in ETL Application?

2 11920

How to improve the performance of Aggregate transformation?

Dmss,

3 14322

What is critical mapping?

2 11382

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 19918

How to view and Generate Metadata Reports?

1 7834

what is difference between COM & DCOM?

Satyam,

1 11205

what is the gap analysis?

1 9514

How to recover sessions in concurrent batches?

3 15742

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 25301

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23338

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 14277

Where is the cache stored in informatica?

Infosys, Satyam,

5 38225

Un-Answered Questions { Data Warehouse }

Mention few power centre client applications with their basic purpose?

951

Explain piconet?

961

Which lifecycle we will use for reporting?

974

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2494

What are the modules in Power Center

1680

how can we analyze the locks ?

2132

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4744

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

what is sas application server? : Sas-di

1078

Explain fact structure?

986

Why and when do you use proc sql?

1247

what is a prompt value in report studio and variables ?

2714

Can you explain surrogate key?

1040

What is the scenario which compels informatica server to reject files?

1070

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