1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category
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?

 1751

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

 2 5614

what is a test load?

 3 15417

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

 1826

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

 1 5448

how do u implement configuration management in Informatica?

 4361

what are business components in Informatica?

 2 10206

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

 2450

can cubes contain measures ?

 1638

can be used COM component in Informatica ?

 1611

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

 2 3700

when will use SQL override in a lookup transformation?

 1865

Two different admin users created for repository are________and_________.

 1 3224

Two default user groups created in the repository are____and_____.

 1643

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?

 1445

Post New ETL Questions

Un-Answered Questions { ETL }

how to connect to a flatfile through ftp in informatica

13431

what is pmrep command?

1949

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1647

What are the types of Data Warehouse applications?

506

What are the various tools used in etl?

541




what is pmrep command?

1941

explain the methodology of Data Warehousing?(Polaries)

1793

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1517

what is the use of server?

1730

Explain about etl data integration software?

480

What are the differences between sql override and update override?

570

Difference between flat files and relational sources?

1726

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

1508

Explain what is etl process? How many steps etl contains explain with example?

499

What is staging area referring to?

569

For More Un-Answered { ETL } Questions Click Here