Six Stars

scanario

Hi,

 

Any one could please help me on below scenario its urgent.

 

I have two tables, need to compare the columns( dates values)  between two tables.

 

1) Table1: select max(Date_col) from tbl1

2) Table2: select max(Date_col) from tbl2;

3) compression between two tables

step 1:  if tbl1.date_col == tbl2.date_col found then

              run subjob2

          jump step 3

     else

        if not found  (tbl1.date_col <>  tbl2.date_col )

        Go to step 1: every 15min check

           infinity loop.

step 3: exit

 

Thanks

shree

 

 

 

5 REPLIES
Six Stars

Re: scanario

Hi

 

Above logic can be achieve using tloop components?

 

Thanks

shree

Six Stars

Re: scanario

Hi ,

 

You can achieve by using tInfiniteLoop component to iterate you subjob which will check  tbl1.date_col == tbl2.date_col.

Wait time has to be provided in milliseconds. 

 

tloop component is used to loop for finite number of iterations.

 

I would suggest to loop job using cron if you are using open source version and you can use TAC for enterprise version rather than tInfiniteLoop component  if you are delivering project to client . Because to stop or change execution frequency you have to modify job which is not good practice.

 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

 

 

Six Stars

Re: scanario

Hi,

 

Thanks for your inputs.

 

We are using talend open studio in window system.  

 

can you tell me some flow how to design?

 

Thanks

Shree

 

 

Six Stars

Re: scanario

 

You can go through following link to check scheduling on windows

 

http://etladvisors.com/2014/05/06/windows-deployment-and-scheduling-of-talend-jobs/

 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Six Stars

Re: scanario

Thanks for your time and inputs.

 

Fine, i am going to use window scheduler for scheduling the jobs.

 

Could you please tell me the design point of view  and scheduler? whether i need to create separate jobs? It's urgent.

 

1) Table1: select max(Date_col) from tbl1
2) Table2: select max(Date_col) from tbl2;
3) compression between two tables
step 1: if tbl1.date_col == tbl2.date_col found then
run subjob2
jump step 3
else
if not found (tbl1.date_col <> tbl2.date_col )
Go to step 1: every 15min check
infinity loop.
step 3: exit

 

Thanks

Shree