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 63860

What is the difference between Normal load and Bulk load?

5 51215

Discuss the advantages & Disadvantages of star & snowflake schema?

5 47039

what is a time dimension? give an example?

IBM,

2 12751

What are the reusable transforamtions?

1 5098

What is aggregate cache in aggregator transforamtion?

5 10008

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

3 7431

In which circumstances that informatica server creates Reject files?

2 10263

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

2 11910

When the informatica server marks that a batch is failed?

1 6125

What is a command that used to run a batch?

2 7618

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

4 11091

Define informatica repository?

Wipro,

2 12178

What are the types of metadata that stores in repository?

2 11149

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

TCS,

2 38285

Un-Answered Questions { Data Warehouse }

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729

What is primary index and secondary index?

1074

Describe in detail about lookup?

1129

How to generate or load values in to the target table based on a column value using informatica etl tool.

1120

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1168

How would you include common or reuse to be processed along with your statements?

2423

Explain substr function?

1167

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

1023

What is a Folder?

1242

Do you know what a local lookup is?

1268

how many types of viewers available in tm1?

How can we run the graph? How can we schedule the graph in unix?

1007

what is user variable in affinium campaign? and some real time examples.

4234

Why sorter is an active transformation?

1254

Give the benefits of data integration suite?

963

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