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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables