Answer / sbhash

1. Connect J2 to J1 and J3. Connect J2 to J1 and
J3. 'Expression Type' as 'OK -(Conditional) or Custom -
(Conditional)' and for 'Custom - (Conditional)', put
constraint as J2.$JobStatus < 3.

2. Create a sequence without any Links between these jobs
and rund then those jobs will run in parelell.

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,

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

How a routine is called in datastage job?

0 Answers  

---

How you Remove the Dataset in Unix?

5 Answers  

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

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

5 Answers   Cap Gemini,

---

What are the repository tables in datastage?

0 Answers  

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

0 Answers   Wipro,

---