QUESTION: 9

Which methods car you use to specify the schema in a tFilelnputDelimited component? Choose 3 answers

Drag a generic schema metadata item onto the Designer.
Add the component then drag and drop a generic schema metadata item onto the component.
Add the schema to the component using the Schema Editor
Drag a File delimited metadata item from the Repository onto the design workspace.
Add the component, open the Component view, select the Built-in schema type, then click the Edit schema button.

Answer(s): B,D,E

Explanation:

The methods that you can use to specify the schema in a tFileInputDelimited component are:
Add the component then drag and drop a generic schema metadata item onto the component. This method allows you to reuse an existing schema that is stored in the Metadata section of the Repository. A generic schema is a schema that is not associated with any specific file format or connection type. You can create a generic schema by right-clicking on Generic Schema in the Repository and selecting Create Generic Schema.
Drag a File delimited metadata item from the Repository onto the design workspace. This method allows you to create a new tFileInputDelimited component with a predefined schema that is based on a specific delimited file. A File delimited metadata item is a metadata item that contains information about a delimited file, such as its path, format, encoding, field separator, etc. You can create a File delimited metadata item by right-clicking on File delimited in the Repository and selecting Create File delimited.
Add the component, open the Component view, select the Built-in schema type, then click the Edit schema button. This method allows you to create a custom schema for the tFileInputDelimited component within the Component view. A built-in schema is a schema that is defined locally for a specific component and cannot be reused by other components. You can edit a built-in schema by clicking on the Edit schema button in the Basic settings tab of the Component view.

Reveal Solution Next Question

QUESTION: 10

You are using the tMap component to configure a mapping.
What do the tables on the left side of the Map Editor window represent?

Explosions to apply to the input data
Schemas of the output rows
Schemas of the input rows
Expression to apply to the output data

Answer(s): C

Explanation:

The tables on the left side of the Map Editor window represent the schemas of the input rows. The schemas define the structure and type of the data that is coming from the input components connected to the tMap component. You can drag and drop columns from the input tables to the output tables on the right side of the Map Editor window to create mappings and transformations.

Reveal Solution Next Question

QUESTION: 11

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?

Int nb_line-(integer)globalMap.put(`'tFileInputDelimited_1_NB_LINE'')
Int nb_line=(integer)globalMap.put(`'tFileInputDelimited_1_NB_LINE'')
Int nb.line-(integer)globalMap.put(`'tFileInputDelimited_1_NB_LINE'')
Int nb_line-(String )globalMap.put(`'tFileInputDelimited_1_NB_LINE'')

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

Reveal Solution Next Question

QUESTION: 12

Which parameters are defined in File Delimited metadata? Choose? answers

Position of the fields
ROW Separator
File Path
Component with which the metadata is associated

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

Reveal Solution Next Question

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

QUESTION: 9

Explanation:

QUESTION: 10

Explanation:

QUESTION: 11

Explanation:

QUESTION: 12

Explanation:

Data-Integration-Developer Exam Discussions & Posts