Oracle ETL Interview Questions
Questions Answers Views Company eMail

What are materialized views & where do we use them? What is a materialized view?

1

What is a staging area? Do we need it?

1

When do you analyze the tables?

1




Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

1

What are parameter files? Where do we use them?

1

What is the purpose of a staging area?

1

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

1

What are active transformation / passive transformations?

1




I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1

What are the various tools? - Name a few?

1

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1

Where do we use connected and un connected lookups?

1

How to determine what records to extract?

1

What are materialized views & where do we use them? What is a materialized view log?

1

How do you analyze the tables

1


Post New Oracle ETL Questions






Un-Answered Questions { Oracle ETL }

What is the purpose of a staging area?

1


What is a staging area? Do we need it?

1


Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

1


Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

1


What are the various tools? - Name a few?

1






What are materialized views & where do we use them? What is a materialized view?

1


How do you analyze the tables

1


I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1


How to determine what records to extract?

1


What are parameter files? Where do we use them?

1


When do you analyze the tables?

1


What are materialized views & where do we use them? What is a materialized view log?

1


What are active transformation / passive transformations?

1


Where do we use connected and un connected lookups?

1


What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1