Talend: How To Resolve OutOfMemoryError: Java heap space

When we try to process large data with Talend Studio on your computer, you may get OutOfMemoryError.

Exception in thread “main” java.lang.OutOfMemoryError: Java heap space

To resolve this error, you need to increase the Xmx parameter in the config file (such as Talend-Studio-win-x86_64.ini or TOS_DI-win-x86_64.ini). By default, the value is set to 1536mb. To increase this parameter, you need to keep it mind the overall spec of your computer (especially the amount of RAM). As suggestion, you can perhaps start off with 2048 or 4096.

ETL
Running Jobs with Informatica Cloud REST API

Informatica Cloud offers REST API for us to interact with the platform programmatically. At this point in time, the latest official reference is found here. In this post, we are going to use Python to trigger jobs through API. Triggering a job is a 2-step process. We need to authenticate …

ETL
Tips and Troubleshooting For Uploading CSV to Database In Talend

There will be time when you want to upload a big csv file (with many rows and hundreds of columns) to a relational database table. Talend Open Studio is an open source ETL tool that I use regularly to do odd jobs like that. I like using it because it …

ETL
How To Rename Mapping Job In Informatica Cloud

Mappings are where all the magic happens in Informatica Cloud. When I started using it, it took me a while to work out how to rename a mapping job. Since then, a few people asked me the same question. So, I decided to write about it. This is probably the …