In the tMap component, where do you set up a filter on the input fields?

In the tMap component, where do you set up a filter on the input fields?
A . Match Model parameter field for fine of the inputs
B . Expression field for a single column of the output
C . Expression filter in the output table
D . Match Model parameter field for one of the main inputs

Answer: C

Explanation:

The tMap component allows you to set up a filter on the input fields by using the Expression filter in the output table. The Expression filter is a field where you can enter a logical expression that evaluates to true or false for each input row. For example, if you want to filter out the rows that have null values in a certain column, you can use row1.column != null as the expression filter for that output. The expression filter applies to all the input fields of the row, not just a single column. You cannot set up a filter on the input fields by using the Match Model parameter field for one of the inputs or outputs, as this field is used to define how to match rows between different inputs or outputs based on a key attribute.

Reference: Talend Open Studio: Open-source ETL and Free Data Integration | Talend

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments