Answer Posted / satya

run u r job in sequencial mode and sort the source data
then play with stage variable's in Transformer.

because in parallel mode data is partioned .

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2013

---

Difference between in process and inter process?

1180

---

I have a few records just I want to store data in to targets cycling way how?

2312

---

Can you explain tagbatch restructure operator?

1126

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1344

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3615

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

764

---

how to export or import the jobs in .ISX file

1143

---

Define APT_CONFIG in Datastage?

1034

---

how to write server Routine coding?

2077

---

What are the different kinds of views available in a datastage director?

990

---

Define Merge?

1269

---

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

1088

---

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

1016

---

Where do the datastage jobs get stored?

1160

---