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 tracing level? How many types of transformations supported by sorted input?

1021

What is a rollup component?

1178

What is the function of aggregator transformation?

1145

What are the different options available for update strategy?

1057

What is the function of union transformation?

1211

What is meant by query override?

1124

What are different types of transformations available in informatica?

1064

What is the difference between a connected look up and unconnected lookup?

1011

What is the use of source qualifier?

1193

What is the function of look up transformation?

1189

What is the use of transformation?

1065

What is the use of code page?

1188

What does reusable transformation mean?

1202

What is main use of mapplet?

1180

What is the way to execute pl/sql script using informatica mapping?

1689

Un-Answered Questions { Data Warehouse }

what is slowly changing dimension? : Sas-di

1188

How are the sources and targets definitions imported in informatica designer?

1176

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2060

What are all the components of Report Studio?

1163

Explain why we use partitioning the session in informatica?

1174

how to abort the job its matain duplicates?

2637

What are the difference between ceil and floor functions in sas?

1408

Difference between in process and inter process?

1320

What is a dimension?

1081

what is session partitioning?

2211

How to performance tune reports?

1278

What are the different types of lookups in datastage?

1116

What is meant by a Clique?

1125

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2542

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2338

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