Oracle Extract Transform Load (ETL) Interview Questions

 
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.
What are the various tools? - Name a few?
7.
What is the difference between Power Center & Power Mart?
8.
What are the various transformation available?
9.
What is ODS (operation data source)?
10.
What is the difference between etl tool and olap tools?
11.
What is the metadata extension?
12.
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?
13.
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?
14.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
15.
What is Full load & Incremental or Refresh load?
16.
How to determine what records to extract?
17.
Do we need an ETL tool? When do we go for the tools in the market?
18.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
19.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
20.
What are parameter files? Where do we use them?
21.
How can we use mapping variables in Informatica? Where do we use them?
22.
What is a mapping, session, worklet, workflow, mapplet?
23.
What is Informatica Metadata and where is it stored?
24.
How do we call shell scripts from informatica?
25.
Can Informatica load heterogeneous targets from heterogeneous sources?
26.
What are the different Lookup methods used in Informatica?
27.
What are active transformation / Passive transformations?
28.
What are the modules in Power Mart?
29.
Compare ETL & Manual development?
30.
When do we Analyze the tables? How do we do it?
31.
What is partitioning? What are the types of partitioning?
32.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
33.
What are the various tools? Name a few?
34.
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
35.
What is fact less fact table? where you have used it in your project?
36.
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
37.
Where do we use connected and un connected lookups?
38.
What are the various tools? - Name a few?
39.
What is the difference between Power Center & Power Mart?
40.
What are the various transformation available?
41.
What is ODS (operation data source)?
42.
What is the difference between etl tool and olap tools?
43.
What is the metadata extension?
44.
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?
45.
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?
46.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
47.
What is Full load & Incremental or Refresh load?
48.
How to determine what records to extract?
49.
Do we need an ETL tool? When do we go for the tools in the market?
50.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
51.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
52.
What are parameter files? Where do we use them?
53.
How can we use mapping variables in Informatica? Where do we use them?
54.
What is a mapping, session, worklet, workflow, mapplet?
55.
What is Informatica Metadata and where is it stored?
56.
How do we call shell scripts from informatica?
57.
Can Informatica load heterogeneous targets from heterogeneous sources?
58.
What are the different Lookup methods used in Informatica?
59.
What are active transformation / Passive transformations?
60.
What are the modules in Power Mart?
61.
Compare ETL & Manual development?
62.
When do we Analyze the tables? How do we do it?
63.
What is partitioning? What are the types of partitioning?
64.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
65.
What are the various tools? Name a few?
66.
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
67.
What is fact less fact table? where you have used it in your project?
68.
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
69.
Where do we use connected and un connected lookups?
70.
What are the various tools? - Name a few?
71.
What is the difference between Power Center & Power Mart?
72.
What are the various transformation available?
73.
What is ODS (operation data source)?
74.
What is the difference between etl tool and olap tools?
75.
What is the metadata extension?
76.
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?
77.
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?
78.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
79.
What is Full load & Incremental or Refresh load?
80.
How to determine what records to extract?
81.
Do we need an ETL tool? When do we go for the tools in the market?
82.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
83.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
84.
What are parameter files? Where do we use them?
85.
How can we use mapping variables in Informatica? Where do we use them?
86.
What is a mapping, session, worklet, workflow, mapplet?
87.
What is Informatica Metadata and where is it stored?
88.
How do we call shell scripts from informatica?
89.
Can Informatica load heterogeneous targets from heterogeneous sources?
90.
What are the different Lookup methods used in Informatica?
91.
What are active transformation / Passive transformations?
92.
What are the modules in Power Mart?
93.
Compare ETL & Manual development?
94.
When do we Analyze the tables? How do we do it?
95.
What is partitioning? What are the types of partitioning?
96.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
97.
What are the various tools? Name a few?
98.
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
99.
What is fact less fact table? where you have used it in your project?
100.
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
101.
Where do we use connected and un connected lookups?
102.
What are the various tools? - Name a few?
103.
What is the difference between Power Center & Power Mart?
104.
What are the various transformation available?
105.
What is ODS (operation data source)?
106.
What is the difference between etl tool and olap tools?
107.
What is the metadata extension?
108.
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?
109.
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?
110.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
111.
What is Full load & Incremental or Refresh load?
112.
How to determine what records to extract?
113.
Do we need an ETL tool? When do we go for the tools in the market?
114.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
115.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
116.
What are parameter files? Where do we use them?
117.
How can we use mapping variables in Informatica? Where do we use them?
118.
What is a mapping, session, worklet, workflow, mapplet?
119.
What is Informatica Metadata and where is it stored?
120.
How do we call shell scripts from informatica?
121.
Can Informatica load heterogeneous targets from heterogeneous sources?
122.
What are the different Lookup methods used in Informatica?
123.
What are active transformation / Passive transformations?
124.
What are the modules in Power Mart?
125.
Compare ETL & Manual development?
126.
When do we Analyze the tables? How do we do it?
127.
What is partitioning? What are the types of partitioning?
128.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?