reading data but not loading

[sekertu]

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

[manodwhb]

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

[sekertu]

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

[manodwhb]

@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

[sekertu]

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

[sekertu · Accepted solution]

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