topic Re: reading data but not loading in Talend Studio

reading data but not loading

sekertu — Fri, 18 Oct 2019 12:37:35 GMT

Hi,

I am new in Talend. I created an incremental job which reads data from mysql data sources with many joins and loads it to mysql output table.

I tried many things. Although my job reads data from sources and it has no error, it doesn't load data to the target.(just 0 row)

I compared the data types and lengths between sources and target.

I don't understand why it doesn't load.

You can find the my job screenshot below.

Please help me about that issue.

Thanks

Tugba

Re: reading data but not loading

manodwhb — Fri, 18 Oct 2019 12:47:32 GMT

@sekertu ,are you doing inner join from the account_archive in tmap? what are you doing in tMap?

Re: reading data but not loading

sekertu — Fri, 18 Oct 2019 13:25:00 GMT

I am doing inner join with user and icurrexchange. And also doing left join with account and account archive. I used math trransformation for round data in tmap

Re: reading data but not loading

manodwhb — Fri, 18 Oct 2019 13:36:40 GMT

@sekertu , I believe you have issue in tmap or data issue ,do you have matching records? I suggest you to create a test job and first do with one table lookup and see are you able to get or not and then add another lookup table and check that are you getting data or not

Re: reading data but not loading

sekertu — Fri, 18 Oct 2019 16:34:35 GMT

Hi Manohar,

Thank you for your advice.

The problem is in my first join. When I tried to join bonus_accounts and user tables(inner join) it reads data but not load as below.

my tMap like below (some columns are blank because I removed the other tables)

Do you have any other advice?

Thank you.

Tugba

Re: reading data but not loading

sekertu — Fri, 18 Oct 2019 17:35:06 GMT

Hi,

I found the problem. I was using function in my source table sql. It changed the value and doesn't allow to join correctly.

I removed the function and it loaded data.

Thank you for the support

Tugba