Why we use partitioning the session in informatica?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / honey
The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments
| Is This Answer Correct ? | 3 Yes | 0 No |
What are the types of lookup?
What is informatica? What exactly are the practical uses in real world
Mention a few design and development best practices for informatica?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
Write the program through which the records can be updated?
State the limitations where we cannot use joiner in the mapping pipeline?
Can any one explain or sujjest some sites for scd mappings.Thank you
What will be the approach?
How can you access the remote source into your session?
What are the mapings that we use for slowly changing dimension table?
why we use source qualifier transformation?