Answer / maruthi

DATA STAGE TRIGGERS USED TO CONTROL JOB ACTIVITIES IN JOB
SEQUENCES,IN JOB SEQUENCES STAGES ARE CALLED AS ACTIVITIES
AND LINKS ARE CALLED AS TRIGGERS.
TRIGGERS ARE OF 3 TYPES.)1.0CONDITIONAL,2.)UN-
CONDITIONAL,3.)OTHER WISE.
SO, BY USING TRIGGERS WE CAN CONTROL THE JOB
ACTIVITIES,USUALLY LARGE DWH JOBS DEPENDS ONE 1 OR 2 JOBS
TO GET DATA,SO BY USING THESE TRIGGERS WE CAN GIVE
CONDITION TO RUN POST JOB ONCE IF PREVIOUS ONE RUNS
SUCCESFULLY

What are the repository tables in datastage?

0 Answers  

---

What are the different type of jobs in datastage?

0 Answers  

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

How to Convert the columns into rows?

2 Answers  

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

---

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

0 Answers  

---

What is aggtorec restructure operator?

0 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

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 &#8722; min_lvl between 0 and 25 inclusive. &#8722; Same column types and headings as Jobs.txt. &#8722; Include column names in the first line of the output file. &#8722; 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 &#8722; min_lvl between 26 and 100 inclusive. &#8722; Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt &#8722; min_lvl between 101 and 500 inclusive. &#8722; Same format and derivations as Target file 1. • Rejects file: JobRejects.txt &#8722; min_lvl is out of range, i.e., below 0 or above 500. &#8722; This file has only two columns: job_id and reject_desc. &#8722; reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: <min_lvl>”, where <min_lvl> is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

0 Answers   HCL,

---