ETL Interview Questions
- How to fine tune the mappings?
- What is the metadata extension?
- What is a three tier data warehouse?
- What are the modules in Power Mart?
- Compare ETL & Manual development?
- What is the diff b/n informatica 7.0&8.0?
- How do you calculate fact table granularity?
- How do we call shell scripts from informatica?
- What are the different versions of Informatica?
- What is Full load & Incremental or Refresh load?
- What are parameter files? Where do we use them?
- When do we analyze the tables? How do we do it?
- What is Informatica Metadata and where is it stored?
- What is latest version of Power Center / Power Mart?
- What are target databases and combined data storage?
- What is the default join that source qualifier provides?
- What is partitioning? What are the types of partitioning?
- What is a mapping, session, worklet, workflow, mapplet?
- What are the different Lookup methods used in Informatica?
- What is the difference between Power Center & Power Mart?
- How is ETL useful in forming data marts and data ware houses?
- Describe two levels in which update strategy transformation sets?
- Do we need an ETL tool? When do we go for the tools in the market?
- Can Informatica load heterogeneous targets from heterogeneous sources?
- What are the basics of converting the format of one database from another?
- How can we use mapping variables in Informatica? Where do we use them?
- What is ETL process? How many steps ETL contains explain with example?
- How much is data structure important for Extraction Transform Load (ETL)?
- What is a staging area? Do we need it? What is the purpose of a staging area?
- What is the difference between active transformation and passive transformation?
- What is target database and how is it useful in Extraction Transform Load (ETL)?
- In what scenario ETL coding is preferred than Database level SQL, PL/SQL coding?
- Can we override a native Sql query within Informatica? Where do we do it? How do we do it?
- How can we minimise the time required for data reading of a data base before transform and load?
- What is the methodology and process followed for ETL testing in Data warehouse environment?
- What are the various methods of getting incremental records or delta records from the source systems?
- What is your expectation regarding your pay packet because you must be having some pre conceived notion?
- What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
- Is there any way to read the MS Excel Data’s directly into Informatica? Like IS there any Possibilities to take excel file as target?
- Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?