what is Partitioning ? where we can use Partition?
Answer Posted / mahesh
The Partitioning Option increases Power Center?s
performance through parallel data processing, and this
option provides a thread-based architecture and automatic
data partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware environments.
Partitions are used to optimize the session performance. We
can select in session properties for partitions
Types- Default----pass through partition, key range
partition, round robin partition, hash partition.
Is This Answer Correct ? | 28 Yes | 5 No |
Post New Answer View All Answers
How to call shell scripts from informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain lookup transformation is active in informatica
What are pre and post-session shell commands?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do you understand by term role-playing dimension?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is dimensional table? Explain the different dimensions.
How to handle decimal places while importing a flatfile into informatica?
Briefly explain the aggregator transformation?
How can informatica be used for an organization?
What are the types of schemas we have in data warehouse.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process