ETL Interview Questions
Questions Answers Views Company eMail

Define Dynamic push down optmization?

HP,

2071

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

ABC,

1 8504

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

TCS,

3 5240

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 7548

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

1514

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.

1590

how many maximum session supports to multiload in teradata ??

IBM,

1882

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

SS Solutions,

1321

What is ROWID explain ?

Wipro,

2 3976

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

Cap Gemini,

2789

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,

1529

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,

1330

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

Tech Mahindra,

1154

what is granularity in Data ware House?

IBM,

1387

What is the difference between project backlog and product backlog?

IBM,

1247


Post New ETL Questions

Un-Answered Questions { ETL }

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

1154


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?

2016


What are the key benefits of ETL Testing?

750


What are the ETL Testing Operations?

810


Explain about power designer data modeling software?

612


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

2141


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

2789


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1558


What is a lookup table in etl?

844


explain the methodology of Data Warehousing?(Polaries)

1993


What are the steps involved in etl process?

711


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

1162


In Which Transformation We Can Use Having Clause In Informatica?

997


what happens if the info.server doesn't find the session parameter in the parameter file?

1717


what is dynamic insert?

1924