ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2119

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 6616

what is a test load?

3 16608

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 is the difference between shortcut of an object and copy of an object? compare them?

1 6091

how do u implement configuration management in Informatica?

4732

what are business components in Informatica?

2 11034

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

2903

can cubes contain measures ?

1980

can be used COM component in Informatica ?

2023

what is the advantage of persistent cache? when it should be used?

2 4615

when will use SQL override in a lookup transformation?

2229

Two different admin users created for repository are________and_________.

1 3828

Two default user groups created in the repository are____and_____.

1977

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

Post New ETL Questions

Un-Answered Questions { ETL }

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

2077

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

1672

What is Data Vault???

2680

how do u identify the changed records in operational data?

2474

When do we analyze the tables?

900

what are Lookup caches options? Including persistent caches.

1895

What are the names of the layers in etl?

941

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2151

Is apache nifi an etl tool?

910

How many steps etl contains?

879

what are the concerns of OLTP and DSS systems?

1899

What is fact? What are the types of facts?

1011

what is pmrep command?

11484

how do use session mapping parameters ?(in which transformation)

1944

What are snapshots?

930

For More Un-Answered { ETL } Questions Click Here