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?

 1755

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

 2 5617

what is a test load?

 3 15424

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

 1833

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

 1 5452

how do u implement configuration management in Informatica?

 4361

what are business components in Informatica?

 2 10210

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

 2453

can cubes contain measures ?

 1639

can be used COM component in Informatica ?

 1615

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

 2 3711

when will use SQL override in a lookup transformation?

 1872

Two different admin users created for repository are________and_________.

 1 3231

Two default user groups created in the repository are____and_____.

 1650

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?

 1447

Post New ETL Questions

Un-Answered Questions { ETL }

can cubes contain measures ?

1639

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.

1393

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

1522

what is session partitioning?

1561

What is the difference between project backlog and product backlog?

1026




What is data modeling and data mining?

554

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1634

How many steps etl contains?

524

What is cube grouping?

557

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1551

Explain about power designer data modeling software?

460

what do u do when DB time takes more?in sap bi

1779

What is the difference between Data Warehousing and Data Mining?

543

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2057

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1467

For More Un-Answered { ETL } Questions Click Here