Wednesday 28 December 2016

What do you understand by MDM in Talend?

Master data management, through which an organization builds and manages a single, consistent, accurate view of key enterprise data, has demonstrated substantial business value including improvements to operational efficiency, marketing effectiveness, strategic planning, and regulatory compliance. To date, however, MDM has been the privilege of a relatively small number of large, resource-rich organizations. Thwarted by the prohibitive costs of proprietary MDM software and the great difficulty of building and maintaining an in-house MDM solution, most organizations have had to forego MDM despite its clear value.

What is tJoin?

tJoin joins two tables by doing an exact match on several columns. It compares columns from the main flow with reference columns from the lookup flow and outputs the main flow data and/or the rejected data.

Which Talend component is used for data transform using buitl in .NET classes?

tDotNETRow helps you facilitate data transform by utilizing custom or built-in .NET classes.

What is tDenormalizeSortedRow?

tDenormalizeSortedRow combines in a group all input sorted rows. Distinct values of the denormalized sorted row are joined with item separators. tDenormalizeSortedRow helps synthesizing sorted input flow to save memory.

What types of joins are supported by the tMap component?

Inner, outer, unique, first, and all joins

What is tMap?

tMap is an advanced component, which integrates itself as plugin to Talend Studio. tMap transforms and routes data from single or multiple sources to single or multiple destinations. It allows you to define the tMap routing and transformation properties.

How can you normalize delimited data in Talend Open Studio?

By using the tNormalize component