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

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1324

How can we update a record in the target table without using update strategy?

1212

What are the advantages of informatica?

1066

Describe the impact of several join conditions and join order in a joiner transformation?

1121

What is persistent lookup cache?

1103

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1312

What are the uses of etl tools?

1179

What are pre and post-session shell commands?

1395

How does the aggregator transformation handle null values?

1197

What are the performance considerations when working with aggregator transformation?

1213

When do you use sql override in a lookup transformation?

1146

How does a sorter cache works?

1110

State the differences between sql override and lookup override?

1300

Name the different lookup cache(s)?

1298

How many input parameters can exist in an unconnected lookup?

1605

Un-Answered Questions { Data Warehouse }

How can we use mapping variables in informatica?

1125

Explain and compare pros and cons of start schemas?

1155

How to delete duplicate row using informatica?

1092

Explain the different lookup methods used in informatica?

1098

Which statement does not perform automatic conversions in comparisons?

1862

What are the steps to import the two data sources in framework manager?

1096

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

What are the advantages of teradata?

1064

How to implement complex jobs in data stage?

1167

How can a graph be run infinitely?

1176

what is metadata? : Sas-bi

1082

Have you ever encountered an error called “depth not equal”?

1228

Mention the validation tools used in SAS?

1239

What is a staging area? What is the purpose of a staging area?

943

explain the function of substr in sas? : Sas-administrator

1070

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