i have two database. first established in godaddy server and second is Mysql that in my PC. godaddy server contain all medical data storage according to our requirement. right now i want to move a particular date data move on my MySql workbench. My job is working fine there is no error but there are some case when am confused whats going on .....
1. if i will move particular date only than in my MySql some rows display. after that i execute again Sql command (select * from newread ); my database values differ .its value always fluctuate.
2. in Active express filter i will use any condition than Talend will not say any error but its does not show any output too.
Kindly share your information.
in this screenshot am using row1.TotalTestCount>=100 . in reality it exists in my godaddy server, its has value.
sometime tmap indicate error but it properly move data.
Run log would be really helpful to actually understand the issue.
Could you try below:
- Reconfigure a new tMap.
- Check writing data into a file/console for a particular date. Later validate if you are getting expected result.
if you are good till now...
- activate the output component and check die on error(if not checked)
It seems some of your data not qualifying the target table structure but some does, that's the reason sometime it loads and sometimes it don't.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.