ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

Eliminating of duplicate records without using dynamic lookups

IBM,

4 15278

what are Lookup caches options? Including persistent caches.

1895

Difference between flat files and relational sources?

Satyam,

2176

what is session partitioning?

1 4366

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

CTS,

2 7110

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

2 5892

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

1906

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

1921

how do u decide whether u need to do aggregations at database level or at Informatica level?

QualTech,

1 3161

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

2077

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?

1846

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1955

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

1931

how do u set partition points in the mapping?

2527

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2216

Post New ETL Questions

Un-Answered Questions { ETL }

When do we analyze the tables?

900

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1748

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

1931

What are the differences between sql override and update override?

1024

When do we go for the tools in the market?

876

what is the difference between cardinality and Nullability?

2901

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1821

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

1906

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

2151

What are the steps involved in etl process?

952

what is the main role of FI on business

2035

What is cube grouping?

996

List few etl bugs?

873

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

2568

What are the names of the layers in etl?

941

For More Un-Answered { ETL } Questions Click Here