Answer Posted / munish
SMP is Symmetric Multi procesasing
MPP is Masively Parallel Processing
Smp supports limited parellelism i.e 64 processors where as
MPP can support N number of nodes or processors [high
performance]
Smp processing is SEQUENTIAL where As MPP Processing can be
PARALLEL
| Is This Answer Correct ? | 18 Yes | 10 No |
Post New Answer View All Answers
Explain the difference between etl tool and olap tools?
What is etl process? How many steps etl contains?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is a worklet?
what is pmrep command?
flat filevalidation in informatica
how to load the data to fact table?
what are the reporting tools and difference between them?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What are materialized views & where do we use them?
where is the cache (lookup, index) created and how can you see it.
What is a lookup table in etl?
What is tracing level?
Explain the key challenges that you face while performing etl testing.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?