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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how many steps are there in etl process?

540


What are the types of Data Warehouse applications?

515


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?

1557


tell me few points when u become TL

2024


In Which Transformation We Can Use Having Clause In Informatica?

825






What is fact? What are the types of facts?

536


What is full load & incremental or refresh load?

685


What is abap? What are idocs?

516


Define slowly changing dimensions (SCD)?

615


what is granularity in Data ware House?

1165


What is virtual Data Warehousing?

550


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

1466


how to load the data to fact table?

2153


Difference between flat files and relational sources?

1770


Explain about the data integration suite features?

473