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

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers   Accenture,


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

0 Answers  


What is partitioning? Explain different types of partitioning?

0 Answers  


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

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 session partitioning?

0 Answers  


what are the production issues in datastage?

0 Answers  


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

0 Answers  


What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


what is granularity in Data ware House?

0 Answers   IBM,


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


What is the difference between Data Warehousing and Data Mining?

0 Answers  


Categories