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 :)

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

What are data elements?

0 Answers  

---

How we can covert server job to a parallel job?

0 Answers  

---

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers  

---

What is "fatal error/rdbms code 3996" error?

0 Answers  

---

what is flow of project?

0 Answers   HSBC, IBM,

---

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---