Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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?

1614

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

2 5274

what is a test load?

3 14945

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1697

what is the difference between shortcut of an object and copy of an object? compare them?

1 5205

how do u implement configuration management in Informatica?

4231

what are business components in Informatica?

2 9832

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

2305

can cubes contain measures ?

1504

can be used COM component in Informatica ?

1466

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

2 3352

when will use SQL override in a lookup transformation?

1738

Two different admin users created for repository are________and_________.

1 3017

Two default user groups created in the repository are____and_____.

1509

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?

1297


Post New ETL Questions

Un-Answered Questions { ETL }

Compare etl & elt?

410


what is the difference between cubes and package in cognos

4313


What do you understand by active and passive transformations?

415


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

1854


how many maximum session supports to multiload in teradata ??

1546






what is pmrep command?

10536


how do u set partition points in the mapping?

1643


How many steps etl contains?

368


list and discuss two approaches for updation of target table in Informatica and how they are different.

1582


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

1118


What are three tier systems in etl?

451


what are the data modeling tools you have used?(polaris)

1397


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

646


In Which Transformation We Can Use Having Clause In Informatica?

682


Explain the use lookup tables and Aggregate tables?

393