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 |
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
which quality process u can approach in ur project
What is the surrogate key?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
What is a dimensional model?
can we create index and drop index in exsisting table while using infomatica
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to delete duplicate row using informatica?
replace multiple spaces with single space.
What are the types of caches in lookup? Explain them.
when we use dynamic lookup,if condition matches what will be the o/p?