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 |
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
What is sql query override? When did u use sql query override?
What are the issues you have faced in your project? How did you overcome those issues?
in which situations do u go for scds ?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
How do you recover rows from a failed session
Scheduling properties,whats the default (sequential)
how DTM buffer size and buffer block size are related
what is meant by data driven.. in which scenario we use that..?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?