Warehouse DataStage Question:
Download Questions PDF

Explain What is the difference between Symetrically parallel processing,Massively parallel processing?

Answer:

Symmetric Multiprocessing (SMP) - Some Hardware resources may be shared by processor. Processor communicate via shared memory and have single operating system.

Cluster or Massively Parallel Processing (MPP) - Known as shared nothing in which each processor have exclusive access to hardware resources. CLuster systems can be physically dispoersed.The processor have their own operatins system and communicate via high speed network

Download Warehouse DataStage Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is merge and how it can be done plz explain with simple example taking 2 tables?What are the command line functions that import and export the DS jobs?