I have 3 jobs A,B & C, which are dependent each other, I want to run A & C jobs daily and B job run only on Sunday. How can I do it?

sudheer

• Aug 20th, 2015

A Job ----> Routine Activity ---Sunday---> B Job ----> C Job
--- Not Sunday -----> C Job

bimaljsr@gmail.com

• Aug 10th, 2015

Sequence Design -

A Job---> (B sequence explained later) --> C Job

B sequence contents
Dummy job to check specific day ---> condition activity with 2 link --> if Sunday run job B, if not Sunday run dummy job and finish.

Answer Question  Select Best Answer

TABLE T1 with c1 and Table T2 with c1 1 3 2 4 2 5 3 4 5 5 6 ...

sivaksa

 Profile Answers by sivaksa Questions by sivaksa

• Aug 13th, 2013

Yes  A is the correct  answer

Dinesh

• Aug 19th, 2011

Use lookup stage...and choose reject option !
you will get the matched records in master output file(3,4,5,5) and unmatched in reject file(1,2,2,6,7).

Answer Question  Select Best Answer

how to perform left outer join and right outer join in lookup stage

sivaksa

 Profile Answers by sivaksa Questions by sivaksa

• Aug 13th, 2013

You need right outer join in lookup..please change the link order like left to right, Right to left put lookup failure condition ..continue...

mallika_chaithu

 Profile Answers by mallika_chaithu Questions by mallika_chaithu

• Jun 9th, 2011

In Lookup stage properties, you will have constraints option. If you click on constraints button- you will get options like continue, drop, fail and rejectIf you select the option continue: it means l...

Answer Question  Select Best Answer

input file A contains12345678910input file B contains6789101112131415Output file X contains12345Output file y contains678910Output file z contains1112131415How can we do in this in a single ds job in px ?....could you please give me the logic to implement ???

Read Best Answer

Editorial / Best Answer

Answered by: vinod chowdary

• Jul 28th, 2011

---

Hello guy's, I would like to solve this by using the Change capture stage. First, i am going to use source as A and refrerence as B both of them are connected to Change capture stage. From, change capture stage it connected to filter stage and then targets X,Y and Z. In the filter stage: keychange column=2 it goes to X [1,2,3,4,5] Keychange column=0 it goes to Y [6,7,8,9,10] Keychange column=1 it goes to Z [11,12,13,14,15] Revert me PLz

Priya Ranjan kumar

• Aug 28th, 2017

You can solve this question in easily way like.
First use the funnel to take the input data from different sources and used check box for unique data(No duplicate data) then
you can use transformer where you can apply logic like. @INROW

Pavan Kumar

• Jul 30th, 2015

Using change capture stage:

File1(Master),File2----> change capture---> Filter ---->
T1, T2, T3
In Filter,
Change_code=1 then send then to T1-->(Insert records)
Change_code=0 then send then to T2-->(Copy records)
Change_code=2 then send then to T3-->(Delete records)

Improve Answer