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

If you want to create indexes after the load process which transformation you choose?

HCL,

3 21529

what happens if you try to create a shortcut to a non- shared folder?

1 6764

what is polling?

Informatica,

1 7227

what is difference between dimention table and fact table?

1 8549

what is worklet and what use of worklet and in which situation we can use it?

Patni, TCS,

4 32169

How to import oracle sequence into Informatica?

Satyam,

3 17007

What is data merging,data cleansing,sampling?

4 10392

What is IQD file?

1 5614

How do you handle decimal places while importing a flatfile into informatica?

1 9309

what is the exact meaning of domain?

3 23619

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 4904

What is the difference between Power Centre and Power Mart?

TCS,

5 21523

why dimenstion tables are denormalized in nature ?

3 9594

What is the use of incremental aggregation?

2 10144

What is the procedure to load the fact table.Give in detail?

1 8858

Un-Answered Questions { Data Warehouse }

Hi, If anyone has base SAS certification dumps, please share.

1868

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1372

What is meant by incremental load?

1096

Explain how to execute the plsql procedure from the report by clicking with mouse?

1050

What is the purpose of having stored procedures in a database?

1152

what is mean by complex business rule ?

2162

write a query to retrieve the latest records from the table sorted by version(scd)

1068

What are the advantages of cognos?

979

What is a sequence generator transformation?

1021

What is the difference between absolute and relative div positioning?

1047

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1010

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1954

how can we analyze the locks ?

2132

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149

What is application.cfm?

1050

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