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?

1275

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

1160

What are the advantages of informatica?

1023

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

1071

What is persistent lookup cache?

1040

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?

1270

What are the uses of etl tools?

1142

What are pre and post-session shell commands?

1326

How does the aggregator transformation handle null values?

1157

What are the performance considerations when working with aggregator transformation?

1162

When do you use sql override in a lookup transformation?

1112

How does a sorter cache works?

1079

State the differences between sql override and lookup override?

1223

Name the different lookup cache(s)?

1247

How many input parameters can exist in an unconnected lookup?

1564

Un-Answered Questions { Data Warehouse }

In sas, what are the areas that you are most interested in? : sas-grid-administration

1091

what is the difference between the report filter and report limit?

980

Explain datastage architecture?

1414

How can we improve session performance in aggregator transformation?

1128

Does Amazon redshift based on concept cluster?

How will you generate test data with no input data?

1185

Differentiate between ceil and floor functions.

1173

How can you increase the performance in joiner transformation?

1208

What is a Cube?

1152

Where the datastage stored his repository?

1102

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1963

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1098

Within a cursor, how would you update fields on the row just fetched?

1087

Explain what task is 98% of the required work of a business analyst?

1118

Explain snowflake schema?

1049

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