ETL Interview Questions
Questions Answers Views Company eMail

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.

1639

what is meant by drill through?(Mascot)

1 3333

what is pmrep command?

1949

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

2 4004

Can u access a repository created in previous version of Informatica?

DELL,

1 4795

Eliminating of duplicate records without using dynamic lookups

1 3405

what are Lookup caches options? Including persistent caches.

1 3928

Difference between flat files and relational sources?

1770

what is session partitioning?

1463

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 14546

Identifying the bottlenecks in various components of Informatica and resolving them.

1508

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

1 3450

what is pmrep command?

1 10816

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

1 4779

Can u access a repository created in previous version of Informatica?

1472


Post New ETL Questions

Un-Answered Questions { ETL }

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2034


Explain and compare etl & manual development?

527


what is pmrep command?

1949


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.

1639


Difference between flat files and relational sources?

1770






explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

3621


how many maximum session supports to multiload in teradata ??

1697


how do u really know that paging to disk is happening while u are using a lookup transform?

1570


Can u access a repository created in previous version of Informatica?

1472


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.

1562


Explain about the data integration suite features?

473


What is virtual Data Warehousing?

552


how to load the data to fact table?

2155


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

1782


What is etl tool in hadoop?

500