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

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1712

What are the differences between oltp and olap?

976

What are the types of schemas we have in data warehouse and what are the difference between them?

946

Differentiate between reusable transformation and mapplet.

1102

Why update strategy and union transformations are active?

1051

What is meant by target load plan?

977

How to join three sources using joiner?

1122

How do you update the records with or without using update strategy?

1121

What are the differences between source qualifier and joiner transformation?

1065

How do you convert single row from source into three rows into target?

1162

What are the types of schemas we have in data warehouse.

965

Why update strategy and union transformations are active? Explain with examples.

1247

How do you remove duplicate records in informatica?

1 1394

How do you load alternate records into different tables through mapping flow?

1875

How do you load first and last records into target table?

1160

Un-Answered Questions { Data Warehouse }

What are attribute roles?

986

Define Routines and their types?

1193

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1699

What are the ETL Testing Operations?

1056

Explain the term 'columns' related to relational database management system?

1075

What is the difference between low affinity and high affinity connections?

1023

What is complex mapping?

1127

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2344

What are the fundamental blocks of co> operating system of ab initio?

1273

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525

What is substr in informatica?

1213

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2702

Mention what dedup-component and replicate component does?

1053

what are several options for creating reports in web report studio? : Sas-bi

1159

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