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!

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

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  

---

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,

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

CHANGE CAPTURE

0 Answers   CTS,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---