Answer / nish

read the dump score and player timings to find out whioch stages/nodes are taking more CPU time for execution.

consider splitting your job into parts optimally and compare the performance with the original design.

try to reduce number of transformer stages.
Check for unnecessary re-partitioning being introduced.

Hope it helps!

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

What are the prerequisites for join stage

2 Answers  

---

How to implement complex jobs in data stage?

0 Answers  

---

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---