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,

2309

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

ABC,

1 9244

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

TCS,

3 5946

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 8440

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

1724

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.

1814

how many maximum session supports to multiload in teradata ??

IBM,

2120

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

SS Solutions,

1547

What is ROWID explain ?

Wipro,

2 4830

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

Cap Gemini,

3027

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,

1807

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,

1522

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

Tech Mahindra,

1401

what is granularity in Data ware House?

IBM,

1733

What is the difference between project backlog and product backlog?

IBM,

1545

Post New ETL Questions

Un-Answered Questions { ETL }

where is the cache (lookup, index) created and how can you see it.

2017

What is a staging area? What is the purpose of a staging area?

891

what make u disappointmnets in u r career

2200

what is Forward,Reverse and Re_engineering?

2203

Explain about etl data integration software?

894

Is hadoop a etl tool?

955

what is the use of server manager?

2137

What are the differences between sql override and update override?

1105

how many maximum session supports to multiload in teradata ??

2120

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

950

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2219

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

2499

what is session partitioning?

1884

What are the steps involved in etl process?

1033

can cubes contain measures ?

2034

For More Un-Answered { ETL } Questions Click Here