Question 1
You need to calculate the total number of rows in an input file using a tMlelnputDelimited
component.
Which code should you use in a tJava component to write a nb-line variable?
- A. Int nb_line-(integer)globalMap.put(‘’tFileInputDelimited_1_NB_LINE’’)
- B. Int nb_line=(integer)globalMap.put(‘’tFileInputDelimited_1_NB_LINE’’)
- C. Int nb.line-(integer)globalMap.put(‘’tFileInputDelimited_1_NB_LINE’’)
- D. Int nb_line-(String )globalMap.put(‘’tFileInputDelimited_1_NB_LINE’’)
Answer:
C
Explanation:
You need to use the following code in a tJava component to write a nb_line variable:
int nb_line = (Integer)globalMap.get(“tFileInputDelimited_1_NB_LINE”);
This code retrieves the value of the global variable tFileInputDelimited_1_NB_LINE, which stores the
number of rows processed by the tFileInputDelimited component, and assigns it to an integer
variable named nb_line. You can then use this variable to print or manipulate the number of rows in
your Job. Note that you need to use globalMap.get, not globalMap.put, to access the value of a
global variable.
Comments
Question 2
Which parameters are defined in File Delimited metadata?
Choose? answers
- A. Position of the fields
- B. ROW Separator
- C. File Path
- D. Component with which the metadata is associated
Answer:
B, C
Explanation:
The parameters that are defined in File Delimited metadata are:
Row separator: This parameter defines the character or string that separates each row of data in a
delimited file. For example, a row separator can be a newline character (\n), a carriage return (\r), or
a combination of both (\r\n).
File path: This parameter defines the location and name of the delimited file that you want to read or
write. You can browse your local system or enter a URL to specify the file path. You can also use
context variables or global variables to make the file path dynamic.
Comments
Question 3
You built multiple Jobs in Studio, each uses its own tDBInput component to connect to a common
database server, but they all use different credentials.
How should you configure the tDBInput components?
- A. Set the Property type to Repository and replace the credential1; in each component.
- B. Set the Property type to Built-in and set all the relevant properties manually.
- C. Set the Database file to Metadata
- D. Set the Property type, to Repository and use a common DB connection metadata
Answer:
B
Explanation:
The tDBInput component allows you to configure the connection properties either by using a built-in
mode or by using a repository mode. The built-in mode lets you set all the relevant properties
manually, such as host, port, database, username, password, etc. The repository mode lets you reuse
an existing connection metadata that is stored in the repository. If you have multiple jobs that use
different credentials to connect to a common database server, you should use the built-in mode and
set the properties for each job individually. This way, you can avoid creating multiple connection
metadata in the repository and maintain them separately. Reference:
Talend Data Integration —
Software to Connect, Access, and Transform Data | Talend
, [tDBInput properties - 7.3]
Comments
Question 4
You have a tMap component whose main input provides the following data:
There is also a lookup table with the following data:
An inner join is configured between the State column of the main input with the State Code column
of the lookup table.
What happens when the row containing the name Andrew laylor is processed?
- A. If an output is configured to collect inner join rejects, the data flows to that output as well as the main output.
- B. If an output is not configured to collect inner join rejects, an error condition is raises.
- C. If an output is not configured to collect inner Join rejects, the data flows to the main output.
- D. If an output is configured to collect inner join rejects, the data flows only to that output.
Answer:
D
Explanation:
The tMap component allows you to perform data transformations and joins between multiple input
sources and output targets. You can configure different types of joins between the main input and
the lookup tables, such as inner join, left outer join, right outer join, etc. An inner join returns only
the matching rows from both tables based on a join condition. If a row from the main input does not
match any row from the lookup table, it is considered as an inner join reject. You can configure an
output to collect these rejects by setting the Catch inner join reject option to true. If you do so, the
data will flow only to that output and not to the main output. If you do not configure an output to
collect the rejects, the data will be ignored and no error will be raised. Reference:
Talend Open
Studio: Open-source ETL and Free Data Integration | Talend
, [tMap properties - 7.3]
Comments
Question 5
Which statements are true about configuring the input sources of a tMap component?
Choose answers
- A. You can use the up and down arrows to interchange the order of the Lookup tables.
- B. Thy main input source is always placed on top and cannot be moved within the tMap component.
- C. The main input source will always be placed on top by default hut ran be dragged to any position.
- D. The order in which the input sources appear on the map does not matter, provided the joins are configured correctly.
Answer:
A, B
Explanation:
The tMap component allows you to configure multiple input sources for your data transformation
and mapping. The main input source is always placed on top of the tMap component and cannot be
moved within it. The main input source provides the data flow that drives the processing of the tMap
component. The lookup tables are placed below the main input source and can be reordered by
using the up and down arrows on the toolbar. The order in which the lookup tables appear on the
tMap component does not affect the functionality of the joins, as long as they are configured
correctly with the appropriate join conditions and expressions. Reference:
Talend Open Studio: Open-
source ETL and Free Data Integration | Talend
, [tMap properties - 7.3]
Comments
Question 6
What determines the name of the tMap output row that delivers join rejects?
- A. The name is predetermined; it is always named Inner join Reject.
- B. The name is determined by the output table you create to catch the rejects.
- C. The name is configurable in the Component view of the tMap component
- D. The name is determined by the input table, you create to generate the rejects.
Answer:
B
Explanation:
The tMap component allows you to configure different types of joins between the main input and
the lookup tables, such as inner join, left outer join, right outer join, etc. An inner join returns only
the matching rows from both tables based on a join condition. If a row from the main input does not
match any row from the lookup table, it is considered as an inner join reject. You can configure an
output to collect these rejects by setting the Catch inner join reject option to true. The name of the
output row that delivers the join rejects is determined by the output table you create to catch the
rejects. You can name the output table as you wish, such as Rejects, Errors, etc. Reference:
Talend
Open Studio: Open-source ETL and Free Data Integration | Talend
,
Comments
Question 7
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?
- A. CA:Thomas Coolidge Andrew TyalorlNY;Calvin Adams;rejects;none
- B. CA:Thomas Coodge;Calvin Adams; rejects:Andrew Taylor
- C. CA:Thomas Coolidge;Ny:Calvin Adams;rejects:Thomas Coolidge, adrew taylor, Calvin Adame
- D. CA:Thomas Coolidge, Andrew Taylor;Ny:Calvin Adams; rejects:Thomas Coolidge, Andrew Taylor,Calvin Adams
Answer:
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
,
Comments
Question 8
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
Comments
Question 9
How are contexts defined?
- A. They are automatically defined by the types of components used in the Job.
- B. Talend Studio defines a default context, and you can define more as needed.
- C. You must define the contexts
- D. In addition to a default context, Talend Studio defines a list of standard contexts you can use in your Ions.
Answer:
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
,
Comments
Question 10
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?
- A. context.Tfblpdtr1
- B. context(path)
- C. contex,(test.Prod).path
- D. context, path
Answer:
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
,
Comments
Page 1 out of 5
Viewing questions 1-10 out of 55
page 2