Oracle ETL Interview Questions And Answers
Oracle Extract transform load (ETL) Interview Questions and Answers will guide us that Extract, transform, and load (ETL) is a process in database usage and especially in data warehousing that involves Extracting data from outside sources, Transforming it to fit operational needs (which can include quality levels), Loading it into the end target, So learn Oracle ETL with the help of this Extract transform load (ETL) Oracle Interview Questions with Answers guide
1 ► What are the various tools? Name a few?
2 ► What are snapshots? What are materialized views & where do we use them? What is a materialized view?
3 ► What is fact less fact table? where you have used it in your project?
4 ► Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
5 ► Where do we use connected and un connected lookups?
6 ► Where do we use semi and non additive facts?
7 ► What are non-additive facts in detail?
8 ► What is a staging area? Do we need it? What is the purpose of a staging area?
9 ► What is a three tier data warehouse?
10 ► What are the various methods of getting incremental records or delta records from the source systems?
11 ► What are the various tools? - Name a few?
12 ► What is latest version of Power Center / Power Mart?
13 ► What is the difference between Power Center & Power Mart?
14 ► What are the various transformation available?
15 ► What is ODS (operation data source)?
16 ► What is the difference between etl tool and olap tools?
17 ► What is the metadata extension?
18 ► What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
19 ► 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?
20 ► Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
21 ► What is Full load & Incremental or Refresh load?
22 ► How to determine what records to extract?
23 ► Do we need an ETL tool? When do we go for the tools in the market?
24 ► Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
25 ► Can we override a native sql query within Informatica? Where do we do it? How do we do it?
26 ► What are parameter files? Where do we use them?
27 ► How can we use mapping variables in Informatica? Where do we use them?
28 ► What is a mapping, session, worklet, workflow, mapplet?
29 ► What is Informatica Metadata and where is it stored?
30 ► How do we call shell scripts from informatica?
31 ► Can Informatica load heterogeneous targets from heterogeneous sources?
32 ► What are the different Lookup methods used in Informatica?
33 ► What are active transformation / Passive transformations?
34 ► What are the modules in Power Mart?
35 ► Compare ETL & Manual development?
36 ► When do we Analyze the tables? How do we do it?
37 ► What is partitioning? What are the types of partitioning?
38 ► What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
- Ads By Google