Answer Posted / maruthi

SMP.)SYMTERRIC MULTI PROCESSING SMP:-ALL PROCESSORS WILL BE
USING SAME MEMORY DISK,MEMORY BUFFERS.HERE PROCESSCORS WILL
BE WAITING FOR DISK I/O PROCESS.
MPP:MASSIVELY PAPALLEL PROCESSING.)HERE EACH PROCESSOR WILL
BE HAVING IT'S OWN MEMORY AND MAMORY DEVICES,PHYISICALLY
ALL THIS PROCESSORS WILL EMBEDDED IN A SINGLE CABIN.AND
WILL COMMUNICATE THROUGH SHARED MEMORY BUSES.
CLUSTER M/C:) SAME AS MPP ,BUT PHYSICALLY THIS M/C ARE
HOUSED IN DIFFERENT CABINS AND WILL COMMUNICATE THROUGH
HIGH SPEED NETWORKS.

Triggers,VIEW,Procedures

800

---

What is use Array size in datastage

1303

---

Define Job control?

676

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

596

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

772

---

---

What are the various kinds of the hash file?

661

---

How to convert RGB Value to Hexadecimal values in datastage?

3456

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3309

---

Terminate Activity

837

---

whom do you report?

1502

---

Is it possible to query a hash file?

1561

---

How many Key we can define in remove duplicate stage?

820

---

How many types of views are there in a datastage director?

832

---

Define ds designer?

766

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

363

---