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 mapping debugger?

1023

Mention a few design and development best practices for informatica?

1005

How can we store previous session logs?

1092

What can we do to improve the performance of informatica aggregator transformation?

1102

How an expression transformation differs from aggregator transformation?

1047

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1096

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1142

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

979

How does a rank transform differ from aggregator transform functions max and min?

1214

What is xml source qualifier transformation in informatica?

1227

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1180

What differs when we choose the sorted input for aggregator transformation?

1035

What do you understand by term role-playing dimension?

1058

What is parallel processing in informatica?

1719

What is meant by lookup transformation? Explain the types of lookup transformation?

956

Un-Answered Questions { Data Warehouse }

How can we Maintain the Cube Security by Category level and Dimension level ?

2368

Explain standard filters?

1014

How to elaborate tracing level?

1188

What is the role of administrative users? : sas-grid-administration

1084

What are the difference between snow flake and star schema?

1012

Explain clustering?

984

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1044

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2045

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1054

What is the basic syntax style in SAS?

1177

What is ibm datastage flow designer?

1156

How does a sorter cache works?

1077

Explain absolute filter?

989

What is Data Vault???

2755

What is the difference between set functions and filter function in dimensional data?

2921

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