Good practices and methods compilation

[Alpha549]

Hello everyone,

I'm looking for a compilation of best practices and methods to integrate data, in several cases.

For instance : to check if data is in one source but not in another, join data (inner join) using a tmap and get rejected data. Rejected data are here the data which are in one source but not in the other one.

Another example : in what cases surrogate keys are necessary and useful, and how to create them...

I'm looking for any URLs, book or anything else.

Thanks !

[Anonymous]

Hi,

    Could you please refer the 4 part Talend Best practice series as a starting point?

Talend Job Designs and Best Practices Part 1	https://www.talend.com/blog/2015/12/07/talend-job-design-patterns-and-best-practices/
Talend Job Designs and Best Practices Part 2	https://www.talend.com/blog/2016/03/30/talend-job-design-patterns-best-practices-part-2/
Talend Job Designs and Best Practices Part 3	https://www.talend.com/resources/talend-job-design-patterns-best-practices-part-3/
Talend Job Designs and Best Practices Part 4	https://www.talend.com/blog/2017/01/05/talend-job-design-patterns-best-practices-part-4/

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Alpha549]

Hello, 

it's helpful but it's not exactly what I'm looking for. I really look for things to do in specific situations, to get specific results.

[Anonymous]

Hi,

   Could you please share your current job design and based on that our community members will be able to provide specific guidelines? 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Alpha549]

Here the point is that there is no specific case (job), it's just about sharing tips concerning things to do in specific cases.

For example, in my first post I said :

"For instance : to check if data is in one source but not in another, join data (inner join) using a tmap and get rejected data. Rejected data are here the data which are in one source but not in the other one.

Another example : in what cases surrogate keys are necessary and useful, and how to create them..."

[Anonymous · Accepted solution]

Hi,

    Right now, we have created best practices at a higher level (as shared in my previous blog) as there are 1000+ connectors in Talend and creating best practice at a modular level may not be practically possible. At the same time, there are lot of webinars and blogs in Talend website for most popular topics and Talend community posts themselves work as points of reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved