Talend Data Integration Certified Developer Exam

The tMysqlOutput component is used to write data into a MySQL database table. The Action on table parameter of this component allows you to specify what operation to perform on the table before loading data into it. The Action on table parameter supports the following operations:

Drop table if exists and create: This operation drops the table if it already exists in the database and creates a new one with the same name and structure as defined in the schema.

Create table: This operation creates a new table in the database with the name and structure as defined in the schema. If a table with the same name already exists, an error will be raised.

Create table if does not exist: This operation creates a new table in the database with the name and structure as defined in the schema only if there is no table with the same name already existing in the database. If a table with the same name already exists, no action will be taken.

The Action on table parameter does not support the following operations:

Replace: This is not an operation on the table, but on the data. The Replace parameter of the tMysqlOutput component allows you to specify whether to replace existing rows in the table with new rows based on a key attribute or to insert new rows only.

Drop table: This is not an operation on the table, but on the database. The Drop table parameter of the tMysqlConnection component allows you to specify whether to drop the table after closing the connection or not.Reference:Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [tMysqlOutput properties - 7.3], [tMysqlConnection properties - 7.3]

Trace Debug mode is a feature that allows you to trace each row processed by your job components and see the values of each column in each row. You can access this mode by opening the Debug Run tab of the Run view and clicking on Trace Debug button.

The capabilities that Trace Debug mode provides are:

Breaking when an input column fulfills a condition. You can set breakpoints on traces based on a condition or an expression that involves input data columns. For example, you can set a breakpoint to pause your job when a customer name contains a certain string or when a product price exceeds a certain value. To set a breakpoint based on a condition, you need to right-click on a trace on your job design workspace and select Show Breakpoint Setup option. This will open a dialog box where you can enter a condition or an expression for your breakpoint.

Advancing one row at a time. You can advance the execution of your job one row at a time by using the Step Over button in the toolbar of the Run view. This will allow you to see how each row is processed by your job components and how it affects the output data.

The capabilities that Trace Debug mode does not provide are:

Filtering which data is propagated by a flow. You cannot filter which data is propagated by a flow in Trace Debug mode. A flow is a link that shows the data transfer between components in your job design workspace. In Trace Debug mode, you can see the data flow on each trace and inspect the values of each column for each row processed by your job. However, you cannot change which rows are propagated by a flow based on a condition or an expression.

Advancing one column at a time. You cannot advance the execution of your job one column at a time in Trace Debug mode. You can only advance the execution of your job one row at a time by using the Step Over button in the toolbar of the Run view. This will allow you to see how each row is processed by your job components and how it affects the output data. However, you cannot see how each column is processed by your job components and how it affects the output data.

Breaking on a selected line of code. You cannot break on a selected line of code in Trace Debug mode. You can only break on a trace based on a condition or an expression that involves input data columns. To break on a selected line of code, you need to use Java Debug mode. Java Debug mode allows you to debug your job code in Java or Perl and see the values of each variable or expression in your code. You can access this mode by switching to the Java perspective and clicking on the Debug button in the toolbar of the Code view.Reference:Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [Trace Debug mode - 7.3], [Java Debug mode - 7.3]

To create a Joblet from an existing Job, you can follow these steps:

Open the Job that you want to create a Joblet from.

Select the components that you want to include in the Joblet.

Right-click on the selected components and selectCreate Jobletfrom the context menu.

In theCreate Jobletdialog box, enter a name and description for the Joblet.

ClickFinishto create the Joblet.

Talend Open Studio User Guide: Creating a Joblet from a Job: https://help.talend.com/r/en-US/8.0/studio-user-guide/creating-joblet-from-job

Trace Debug and Java Debug are two modes that allow you to debug your jobs in Talend Studio. Trace Debug mode allows you to trace each row processed by your job components and see the values of each column in each row. Java Debug mode allows you to debug your job code in Java or Perl and see the values of each variable or expression in your code.

The characteristics that distinguish Trace Debug from Java Debug are:

Trace Debug mode allows row-by-row inspection of data flows, while Java Debug mode does not. Data flows are the links that show the data transfer between components in your job design workspace. In Trace Debug mode, you can see the data flow on each trace and inspect the values of each column for each row processed by your job. You can also use filters to display only the rows that match a condition or an expression. In Java Debug mode, you cannot see the data flow on each trace or inspect the values of each column for each row.

Trace Debug mode supports breakpoints based on input data condition, while Java Debug mode does not. Breakpoints are points where the execution of your job pauses and waits for your action. You can use breakpoints to inspect your data or debug your logic at specific points of your job execution. In Trace Debug mode, you can set breakpoints on traces based on a condition or an expression that involves input data columns. For example, you can set a breakpoint to pause your job when a customer name contains a certain string or when a product price exceeds a certain value. In Java Debug mode, you can only set breakpoints on lines of code based on a condition or an expression that involves variables or expressions.

The characteristics that do not distinguish Trace Debug from Java Debug are:

Both modes require a separate perspective. A perspective is a set of views and editors that are arranged in a specific way to support a specific task. In Talend Studio, you can switch between different perspectives, such as Integration, Debug, Profiling, etc. To use Trace Debug mode, you need to switch to the Debug perspective by clicking on the Open Perspective button and selecting Debug. To use Java Debug mode, you need to switch to the Java perspective by clicking on the Open Perspective button and selecting Java.

Neither mode requires Java development experience. Although Java Debug mode allows you to debug your job code in Java or Perl, you do not need to have Java development experience to use it. You can use the graphical interface of Talend Studio to design your job components and properties without writing any code. You can also use the Code view to see the generated code of your job in Java or Perl and modify it if needed. However, you do not need to write any code from scratch or understand all the details of the code to use Java Debug mode.Reference:Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [Trace Debug mode - 7.3], [Java Debug mode - 7.3]

To create a Joblet from an existing Job, you can follow these steps:

Open the Job that you want to create a Joblet from.

Select the components that you want to include in the Joblet.

Right-click on the selected components and selectCreate Jobletfrom the context menu.

In theCreate Jobletdialog box, enter a name and description for the Joblet.

ClickFinishto create the Joblet.

Talend Open Studio User Guide: Creating a Joblet from a Job: https://help.talend.com/r/en-US/8.0/studio-user-guide/creating-joblet-from-job