Talend DI use cases

[singhg]

Hi Talend community,

I want to implement below uses cases in Talend DI tool. Please let me know if these are possible:-

1.) Data validation- Is there any component in talend which can validate the input data from column. Like State, Country, Pincode etc, The component should query the internet/web to verify. It should not lookup the reference tables having the master data.
2.) Is it possible to migrate informatica mapping to talend job vice-versa.

3.) Can I create a data lineage out of talend mapping.

4.) Any component which can create test data for various domains like pharma, banking, retail, aviation etc.

Thanks

Gurpreet

[manodwhb · Accepted solution]

@singhg ,please find then below answers.

1) for data validation you can use tSchemaCompilanceCheck

2) since we do not have tool  to migrate directly form informataica job to Talend vice versa,since you have design manually.

3) regarding data linage check the below link.https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/0ngG8m9eph38MDRZh~c48w

4) you can create a test data using tRowgenrator,but it would be based on your use case,since it relay not understand pharma, banking, retail, aviation etc.

[Anonymous]

Hi,

   Regarding your first query, Talend is having a specialized component to perform address validation and it will connect to leading address validation providers. Below link can help you to get details for the same.

https://help.talend.com/reader/ma7umU76mX4y~4M03EGm9w/sOUIoW4O9naM5c7d~goSBQ

There are no plug and play Informatica to Talend mapping converter tool.

You need to use the Talend Data Catalog product to build Data Governance and Lineage.

There are no pre-built data generators from Talend. But many of our partners have built these type of tools on top of Talend Products. 

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 🙂

[jilanisyed]

2.) Is it possible to migrate informatica mapping to talend job vice-versa.

We can convert from informatica to Talend.

if you are using Enterprise version we have metatdata bridge plugin . we can use that to convert informatica to Talend jobs . but we need some manual effort to convert transformation and connection details.

[manodwhb]

@jilanisyed ,a simple and short answer is you need manual effort to convert talend job to informatica mapping.