Database Reference
In-Depth Information
Working with sources - the Create option
Apart from importing the file or table structure, we can manually create the source defini-
tion. When the sample source file or the table structure is not available, we need to manu-
ally create the source structure. When we select the
Create
option, we need to define
every detail related to the file or table manually, such as the name of the source, the type
of the source, the column names, the column data type, the column data size, indexes,
constraints, and so on. When you import the structure, the import wizard automatically
imports all these details. We perform the following steps:
1. In the designer screen, navigate to
Tools
|
Source Analyzer
to open the Source
Analyzer.
2. Navigate to
Sources
|
Create
.