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!

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---

How do u view log file for a particular job?

6 Answers   HP,

---

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,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

Why do we use link partitioner and link collector in datastage?

0 Answers  

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

What are the partition techniques available in your last project?

1 Answers  

---