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

ETL Interview Questions

Questions Answers Views Company eMail

Define Dynamic push down optmization?

HP,

2301

Need Informatica Power Center 9.1 free download(for all windows version)

ABC,

1 9238

Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

TCS,

3 5938

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

IBM, Tech Mahindra,

2 8430

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1719

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.

1806

how many maximum session supports to multiload in teradata ??

IBM,

2118

hoe to access second value in mapping parameter if it is having more than one value ?????????????

SS Solutions,

1539

What is ROWID explain ?

Wipro,

2 4815

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

Cap Gemini,

3024

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

Cap Gemini,

1803

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

Cap Gemini,

1521

if i have a query as flat file how can we load data to target table

Tech Mahindra,

1398

what is granularity in Data ware House?

IBM,

1724

What is the difference between project backlog and product backlog?

IBM,

1533

Post New ETL Questions

Un-Answered Questions { ETL }

State the differences between shortcut and reusable transformation

1056

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?

2241

What is initial load and what is full load?

987

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

1264

What is staging area referring to?

1130

What is etl process? How many steps etl contains?

1034

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2536

what is a worklet?

994

Explain about power designer data modeling software?

850

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

2081

What are the etl testing operations includes?

1111

In Which Transformation We Can Use Having Clause In Informatica?

1242

if i have a query as flat file how can we load data to target table

1398

how do u set partition points in the mapping?

2239

Explain about round-robi?

1148

For More Un-Answered { ETL } Questions Click Here