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

how will u design file watch jobs?

2 Answers  

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

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

0 Answers   IBM,

---

what is factless fact table?

3 Answers   IBM,

---

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

What are the areas of application?

0 Answers  

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---