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,

2242

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

ABC,

1 9111

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

TCS,

3 5766

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 8315

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

1672

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 many maximum session supports to multiload in teradata ??

IBM,

2042

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

SS Solutions,

1482

What is ROWID explain ?

Wipro,

2 4659

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

Cap Gemini,

2964

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,

1746

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,

1480

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

Tech Mahindra,

1337

what is granularity in Data ware House?

IBM,

1654

What is the difference between project backlog and product backlog?

IBM,

1444

Post New ETL Questions

Un-Answered Questions { ETL }

Explain do we need an etl tool? When do we go for the tools in the market?

964

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

1204

What are the different etl testing categories as per their function?

1004

What is meant by incremental load?

1017

can cubes contain measures ?

1980

What are the steps involved in etl process?

952

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2224

What are the differences between sql override and update override?

1024

What are snapshots?

930

Can we create Hierarchies in generic datasources?

2328

what are the concerns of OLTP and DSS systems?

1899

how to load the data to fact table?

2638

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2494

what are the types in error loging?

2091

How to delete data which is not in source table?

1269

For More Un-Answered { ETL } Questions Click Here