Create a Source

A Model Object of type Source can be created in the Source Layer.

What is a Source

A Source represents the structure of a source object in the source system. 

Creation steps

There are three ways to create a Source Model Object:

• From the Discovery of a Source System (recommended)
• From a Linked Project (recommended)
• Manually (not recommended, intended only for testing or POC purposes)

• • Create a Model Object of type Source in the Source Layer

Properties

A Source Model Object can be customized using the following Properties in the Microsoft SQL Server - Stage Files generator only:

• File Extension
• File Group Pattern
• Column Collation
• Column Delimiter
• Row Delimiter
• Batch Size
• Code Page
• Field Quote
• First Data Row

Default Terms

A Source Model Object does not include any Default Terms.