ETL Interview Questions
Questions Answers Views Company eMail

Define Dynamic push down optmization?

HP,

1901

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

ABC,

1 7831

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

TCS,

3 4683

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 6698

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

1340

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.

1382

how many maximum session supports to multiload in teradata ??

IBM,

1680

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

SS Solutions,

1120

What is ROWID explain ?

Wipro,

2 3260

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

Cap Gemini,

2551

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,

1295

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,

1136

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

Tech Mahindra,

963

what is granularity in Data ware House?

IBM,

1154

What is the difference between project backlog and product backlog?

IBM,

1017


Post New ETL Questions

Un-Answered Questions { ETL }

Mention few test cases and explain them?

537


what is session partitioning?

1555


what is granularity in Data ware House?

1154


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

1340


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

1492






how does the server recongnise the source and target databases.Elaborate on this

2084


Do we need an etl tool?

542


tell me few points when u become TL

2013


How to delete data which is not in source table?

822


What are various etl tools in the market?

515


Difference between flat files and relational sources?

1722


What is partitioning? Explain about round-robin, hash partitioning.

539


How to fine tune mappings?

556


how to connect to a flatfile through ftp in informatica

13418


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

775