Why we use partitioning the session in informatica?

Answer Posted / swetha

Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.

Is This Answer Correct ?    14 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a rank transform differ from aggregator transform functions max and min?

899


What are the differences between a connected lookup and unconnected lookup?

817


How can we store previous session logs?

768


What is session task and command task?

835


Design a mapping to load the cumulative sum of salaries of employees into target table?

1172


Explain the types of transformations?

783


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1851


What are the performance considerations when working with aggregator transformation?

896


What is the difference between STOP and ABORT options in Workflow Monitor?

934


Slowly changing dimensions, types and where will you use them

1462


What is informatica powercenter repository?

912


Can you generate sequence numbers without using the sequence generator transformation?

798


Explain the pipeline partition with real time example?

867


what is mean by complex business rule ?

1886


Tell me about Propagate functions in informatica

700