how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?



how do u estimate the number of partitions that a mapping really requires? Is it dependent on the m..

Answer / tcs

There is no particular rule that says that mapping has to be
partitioned.But we can do so to improve the performence.Yes,it
depends on the machine configuration, as it uses the system
memory to run those sessions

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  


What are the names of the layers in etl?

0 Answers  


When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  


Can we create Hierarchies in generic datasources?

0 Answers   CTS,


Explain etl mapping sheets?

0 Answers  






what is the difference between OLTP database and data warehousing database?

4 Answers  


What are the differences between sql override and update override?

0 Answers  


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


what is Forward,Reverse and Re_engineering?

0 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


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

0 Answers  


if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,


Categories