Extract, Transform, Load (ETL) Interview Questions

 
1.
How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
2.
Explain What is partitioning? What are the types of partitioning?
3.
Explain Do we need an ETL tool? When do we go for the tools in the market?
4.
Explain What is Informatica Metadata and where is it stored?
5.
Explain What is ETL process ?How many steps ETL contains explain with example?
6.
How to call shell scripts from informatica?
7.
Explain What is the metadata extension?
8.
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
9.
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
10.
Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
11.
Explain What are the various methods of getting incremental records or delta records from the source systems?
12.
Explain What is a staging area? Do we need it? What is the purpose of a staging area?
13.
Explain What is Full load & Incremental or Refresh load?
14.
Explain a mapping, session, worklet, workflow, mapplet?
15.
Tell me what is Full load & Incremental or Refresh load?
16.
Explain What is a three tier data warehouse?
17.
Explain What is the difference between Power Center & Power Mart?
18.
Explain Where do we use semi and non additive facts?
19.
How can we determine what records to extract?
20.
Explain the different Lookup methods used in Informatica?
21.
Explain 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?
22.
Explain the difference between keylokup and joiner?
23.
Explain and Compare ETL & Manual development?
24.
Explain When do we Analyze the tables? How do we do it?
25.
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
26.
Explain What are the different versions of Informatica?
27.
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
28.
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
29.
Explain What are the various transformation available?
30.
Explain the difference between etl tool and olap tools?
31.
How to extract SAP data Using Informatica? What is ABAP? What are IDOCS?
32.
Explain What are the modules in Power Mart?
33.
How to calculate fact table granularity?
34.
What is latest version of Power Center / Power Mart?
35.
What are the various tools? Explain Name a few?
36.
Explain if a flat file cotains 1000 records how can i get first and last records only?
37.
Explain What is ODS (operation data source)?
38.
How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
39.
Explain What is partitioning? What are the types of partitioning?
40.
Explain Do we need an ETL tool? When do we go for the tools in the market?
41.
Explain What is Informatica Metadata and where is it stored?
42.
Explain What is ETL process ?How many steps ETL contains explain with example?
43.
How to call shell scripts from informatica?
44.
Explain What is the metadata extension?
45.
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
46.
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
47.
Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
48.
Explain What are the various methods of getting incremental records or delta records from the source systems?
49.
Explain What is a staging area? Do we need it? What is the purpose of a staging area?
50.
Explain What is Full load & Incremental or Refresh load?
51.
Explain a mapping, session, worklet, workflow, mapplet?
52.
Tell me what is Full load & Incremental or Refresh load?
53.
Explain What is a three tier data warehouse?
54.
Explain What is the difference between Power Center & Power Mart?
55.
Explain Where do we use semi and non additive facts?
56.
How can we determine what records to extract?
57.
Explain the different Lookup methods used in Informatica?
58.
Explain 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?
59.
Explain the difference between keylokup and joiner?
60.
Explain and Compare ETL & Manual development?
61.
Explain When do we Analyze the tables? How do we do it?
62.
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
63.
Explain What are the different versions of Informatica?
64.
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
65.
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
66.
Explain What are the various transformation available?
67.
Explain the difference between etl tool and olap tools?
68.
How to extract SAP data Using Informatica? What is ABAP? What are IDOCS?
69.
Explain What are the modules in Power Mart?
70.
How to calculate fact table granularity?
71.
What is latest version of Power Center / Power Mart?
72.
What are the various tools? Explain Name a few?
73.
Explain if a flat file cotains 1000 records how can i get first and last records only?
74.
Explain What is ODS (operation data source)?
75.
What is latest version of Power Center / Power Mart?
76.
What is latest version of Power Center / Power Mart?
77.
What is latest version of Power Center / Power Mart?
78.
What is latest version of Power Center / Power Mart?