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 9112

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 8317

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 4661

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,

1338

what is granularity in Data ware House?

IBM,

1655

What is the difference between project backlog and product backlog?

IBM,

1444

Post New ETL Questions

Un-Answered Questions { ETL }

What is Data Vault???

2681

How many steps etl contains explain with example?

882

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2175

dimension object created in oracle can be imported in designer?how?

2904

What is cube grouping?

996

Can u access a repository created in previous version of Informatica?

1804

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

1672

where are the log files generally stored.Can you change the path of the file.what can the path be?

2374

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

2372

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

2964

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

2444

What is a mapping, session, worklet, workflow, mapplet?

919

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

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1904

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

1344

For More Un-Answered { ETL } Questions Click Here