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 junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 62827

What is the difference between Normal load and Bulk load?

5 50690

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46557

what is a time dimension? give an example?

IBM,

2 12479

What are the reusable transforamtions?

1 4928

What is aggregate cache in aggregator transforamtion?

5 9632

What are the basic needs to join two sources in a source qualifier?

3 7186

In which circumstances that informatica server creates Reject files?

2 10056

Can you copy the session to a different folder or repository?

2 11689

When the informatica server marks that a batch is failed?

1 5881

What is a command that used to run a batch?

2 7387

In a sequential batch can you run the session if previous session fails?

4 10708

Define informatica repository?

Wipro,

2 11951

What are the types of metadata that stores in repository?

2 10939

What is tracing level and what are the types of tracing level?

TCS,

2 37998

Un-Answered Questions { Data Warehouse }

What is a mapping?

942

list out all the transformations which use cache?

1125

What is difference macros and prompts?

2233

what is size of u r database?

2260

Explain is there any default username & pwd for bo designer & supervisor?

955

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2205

Suggest a good author for hyperion in data warehousing?

899

What is datastage?

1040

Partition, what happens if the specified key range is shorter and longer

2444

What a datastage macro?

1011

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2297

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

992

What are the advantages of cold fusion?

911

For faster process, what we will do with the universe?

949

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1923

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