Answer / babu

hai Ankit,

we have to give only for jobactivity1(failed conditional),
remaining jobactivity2 and jobactivity3 have unconditional otherwise ok conditional...

(I think)


thanks.

Answer / ankit gosain

Hi All,

Create three job acitivities like:


JobActivity1-------->JObAcitivity2
|
|
|
JobActivity3

Now, double click on JobActivity1, and go to the trigger
tab, make the expression type for both the JobActivity2 &
JobActivity3 as failed - (Conditional).
Then both the jobs will run if and only if when the first
job will get aborted.

Cheers,
Ankit :)

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

1 Answers  

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

How do you import and export data into datastage?

0 Answers  

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

How did you reconcile source with target?

2 Answers   HP,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

What are stage variables, derivations and constants?

0 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---