topic Re: scanario in Talend Studio

scanario

Anonymous — Thu, 28 Sep 2017 07:31:01 GMT

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

Re: scanario

Anonymous — Thu, 28 Sep 2017 08:30:13 GMT

Above logic can be achieve using tloop components?

Thanks

shree

Re: scanario

shivanand — Thu, 28 Sep 2017 10:24:26 GMT

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.

Re: scanario

Anonymous — Thu, 28 Sep 2017 12:10:50 GMT

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

Re: scanario

shivanand — Thu, 28 Sep 2017 12:48:23 GMT

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.

Re: scanario

Anonymous — Tue, 03 Oct 2017 06:32:56 GMT

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