ETL Interview Questions
Questions Answers Views Company eMail

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

Infosys,

1158

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

1033

What is granularity? Please explain with example

IBM,

1 1652

Explain me ETL project architecture in Detail?

Infosys,

2117

In Which Transformation We Can Use Having Clause In Informatica?

994

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

IBM, Saama Tech, Wipro,

1 1435

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

IBM, Saama Tech, Wipro,

961

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

IBM, Saama Tech, Wipro,

964

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1027

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

IBM, Saama Tech, Wipro,

1 1976

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 3087

What is data modeling and data mining?

727

What are the ETL Testing Operations?

804

Explain the use lookup tables and Aggregate tables?

715

What is data cleaning?

717


Post New ETL Questions

Un-Answered Questions { ETL }

what is the main role of FI on business

1824


What is etl process. How many steps etl contains explain with example?

689


What is tracing level? How many types of transformations supported by sorted input?

736


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2262


What is staging area referring to?

768


what is the use of server manager?

1798


how do u really know that paging to disk is happening while u are using a lookup transform?

1732


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

1984


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1719


how would u estimate the size of Lookup transform data and index cache?

1839


Compare etl & elt?

754


what are the reporting tools and difference between them?

1764


What is full load & incremental or refresh load?

946


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

1826


What is a mapping?

754