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.

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2231

---

how can we create rank using datastage?what is the meaning of rank?

8763

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2847

---

How you Implemented SCD Type 1 & Type 2 in your project?

4113

---

What is datastage engine?

1163

---

What are the different layers in the information server architecture?

1116

---

How many types of stage?

1164

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2207

---

Which warehouse using in your datawarehouse

2173

---

What is oci?

1284

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3640

---

how many rows sorted in sort stage by default in server jobs

3984

---

Does datastage support slowly changing dimensions ?

1095

---

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2706

---

What are stage variables?

1189

---