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

Which methods car you use to specify the schema in a tFilelnputDelimited component? Choose 3 answers
A . Drag a generic schema metadata item onto the Designer.
B . Add the component then drag and drop a generic schema metadata item onto the component.
C . Add the schema to the component using the Schema Editor
D . Drag a File delimited metadata item from the Repository onto the design workspace.
E . Add the component, open the Component view, select the Built-in schema type, then click the Edit schema button.

Answer: 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.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments