Answer / don

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how?
Jobs 1 to 5 are associated into a master seq. for the job activity 1 and 2 we can have "reset" or "validate" option activated and for the jobs 3, 4, 5 we will have "reset if failed then run". Later schedule the Master seq to run as needed.

2.how to schedule the job in datastage?
Go to director Client: choose time line to schedule Master seq or jobs..
many options via 3rd party scheduling tools like: ControlM, TWS, CAWA Autosys etc

what is the diff bet grip and fgrep command?
the fgrep command searches for fixed-character strings in a file or files. "Fixed-character" means the string is interpreted literally — metacharacters do not exist, and therefore regular expressions cannot be used.

how do you cleanse the data in your project
By applying Trim IsNull Convert Field etc functions can be utilized to cleanse the raw data either in tables via SQL or Tfm in DataStage for files based

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

---

What are constraints and derivations?

0 Answers  

---

What a datastage macro?

0 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

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?

0 Answers  

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---

what is the diff between sequential file and fileset stages?

3 Answers  

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---