ETL Interview Questions
Questions Answers Views Company eMail

SCD2 will work on only dimension tables as well as fact Table?

Infosys,

982

Which transformation we use to convert 'NA' to 'Not Available'

853

What is granularity? Please explain with example

IBM,

1 1324

Explain me ETL project architecture in Detail?

Infosys,

1924

In Which Transformation We Can Use Having Clause In Informatica?

823

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 1102

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

782

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

787

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

835

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 1604

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 2669

What is data modeling and data mining?

554

What are the ETL Testing Operations?

618

Explain the use lookup tables and Aggregate tables?

549

What is data cleaning?

549


Post New ETL Questions

Un-Answered Questions { ETL }

List few etl bugs?

526


Explain etl mapping sheets?

660


Explain and compare etl & manual development?

523


Is hadoop a etl tool?

515


Explain about round-robi?

623






Identifying the bottlenecks in various components of Informatica and resolving them.

1504


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1825


What are the steps involved in etl process?

516


Compare etl & elt?

554


What is full load & incremental or refresh load?

684


What are materialized views & where do we use them?

488


How can we use external procedural logic in informatica?

526


What is the difference between project backlog and product backlog?

1026


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1467


Compare ETL & Manual development?

553