ETL Interview Questions
Questions Answers Views Company eMail

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

Infosys,

988

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

862

What is granularity? Please explain with example

IBM,

1 1336

Explain me ETL project architecture in Detail?

Infosys,

1934

In Which Transformation We Can Use Having Clause In Informatica?

835

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

IBM, Saama Tech, Wipro,

1 1118

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

IBM, Saama Tech, Wipro,

790

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

IBM, Saama Tech, Wipro,

796

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

840

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

IBM, Saama Tech, Wipro,

1 1618

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 2683

What is data modeling and data mining?

562

What are the ETL Testing Operations?

636

Explain the use lookup tables and Aggregate tables?

553

What is data cleaning?

557


Post New ETL Questions

Un-Answered Questions { ETL }

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

554


What are three tier systems in etl?

629


Explain do we need an etl tool?

533


what are the concerns of OLTP and DSS systems?

1563


Explain about the data integration suite features?

479






what are the facilities provided by data warehouse to analytical users?

1681


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1821


Explain the difference between etl tool and olap tools?

543


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

1856


Difference between flat files and relational sources?

1739


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2172


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1675


What is etl process? How many steps etl contains?

605


what is data modeling?

1480


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?

1477