QUESTION: 17

You have a tMap component configured with a single input row1 and three outputs: CA, NY, Rejects. The input row1 consists of two columns. Name and State, containing the following data:

All outputs map only the Name column from row1, but CA employs a filter expression, CA.equals(row1.state), while Ny employs a filter expression, NY. Equals(row1, State). All Rejects have no such configuration.
Under these conditions, how does data flow to the outputs?

CA:Thomas Coolidge Andrew TyalorlNY;Calvin Adams;rejects;none
CA:Thomas Coodge;Calvin Adams; rejects:Andrew Taylor
CA:Thomas Coolidge;Ny:Calvin Adams;rejects:Thomas Coolidge, adrew taylor, Calvin Adame
CA:Thomas Coolidge, Andrew Taylor;Ny:Calvin Adams; rejects:Thomas Coolidge, Andrew Taylor,Calvin Adams

Answer(s): B

Explanation:

The tMap component allows you to configure multiple outputs for your data transformation and mapping. You can apply filter expressions on each output to filter out the rows that meet certain criteria. For example, if you want to send only the rows that have CA as the state value to one output, you can use CA.equals(row1.state) as the filter expression for that output. The filter expression evaluates to true or false for each row, and only the rows that evaluate to true are sent to the output. In this case, only Thomas Coolidge and Andrew Taylor have CA as their state value, so they are sent to the CA output. Similarly, only Calvin Adams has NY as his state value, so he is sent to the NY output. The Rejects output has no filter expression, so it receives all the rows from the input by default. However, since there is a conflict between the CA and NY outputs and the Rejects output, only the rows that are not sent to any other output are sent to the Rejects output. In this case, there are no such rows, so the Rejects output receives no data.

Reference:

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

Reveal Solution Next Question

QUESTION: 18

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

Match Model parameter field for fine of the inputs
Expression field for a single column of the output
Expression filter in the output table
Match Model parameter field for one of the main inputs

Answer(s): 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

Reveal Solution Next Question

QUESTION: 19

How are contexts defined?

They are automatically defined by the types of components used in the Job.
Talend Studio defines a default context, and you can define more as needed.
You must define the contexts
In addition to a default context, Talend Studio defines a list of standard contexts you can use in your Ions.

Answer(s): C

Explanation:

Contexts are a way of defining different sets of values for variables that are used in a job. For example, you can define a context for testing and another context for production, with different values for the database connection parameters, file paths, etc. You can then switch between the contexts easily without modifying the job design. Contexts are not automatically defined by the types of components used in the job, nor by Talend Studio. You must define the contexts yourself in the Contexts tab of your job. You can also create context groups in the Repository and reuse them in multiple jobs.

Reference:

Talend Data Integration -- Software to Connect, Access, and Transform Data | Talend,

Reveal Solution Next Question

QUESTION: 20

A Job has two contexts defined: lest (the default) and Prod, and two context variables defined: path and server.
Which expression should you use to reference the path?

context.Tfblpdtr1
context(path)
contex,(test.Prod).path
context, path

Answer(s): D

Explanation:

To reference the value of a context variable you defined, you can use the syntax context.variable_name, where variable_name is the name of the context variable. For example, if you have a context variable named path, you can reference its value by using context.path. You do not need to specify the context name (such as test or prod) or use parentheses or brackets around the variable name.

Reference:

Talend Data Integration -- Software to Connect, Access, and Transform Data | Talend,

Reveal Solution Next Question

Free Data-Integration-Developer Exam Braindumps (page: 5)

QUESTION: 17

Explanation:

Reference:

QUESTION: 18

Explanation:

Reference:

QUESTION: 19

Explanation:

Reference:

QUESTION: 20

Explanation:

Reference: