![]() The user must set a System Type before the table can be created.Īdd a System Type to a source in Target Design (Design > Targets > If the user did not import a System Type in Target Design (i.e., an Excel file import, database table import, or manual entry was used for the target design) an error message displays when the user clicks the Create Source Table icon. NOTE: A System Type must be defined for a source before the table can be built. NOTE: A source table cannot be built for a source of, the Create Source Table icon is disabled. NOTE: To view information about the source in Map, including field mappings and the source schema,Ĭlick Map Source on the Page toolbar of the Automation SQL Target Source page. If the source table already exists in the database, it will be dropped and built again. zLegacy key fields must be mapped manually in Map. The source table uses the natural keys from the legacy system, so if no key fields are defined in the legacy table, no keys are defined in the source table built by SQL AutoGen. ![]() The source table name displays in Map on the Target Sources page’s Vertical NOTE: A user can create all target tables, source tables, Update Row source tables, and rules at one time by clicking the Create All Objects icon on the AutomationĪll objects created using SQL AutoGen are written to the data source defined for the object in Console (Process Area > Objects If disabled target sources are auto-generated with a default status of inactive in Transform. NOTE: If Source Active On Build is enabled on the Parameters page in Console, target sources are auto-generated with a default status of active in Transform. It contains all of the columns from the legacy table, plus zfields used in update rules and columns needed for check tables. The source table is created in the data source defined for the object in Console and is built based on the source database object. The Assemble Where Clause is used to filter source data when importing or refreshing a target. NOTE: An Assemble Where Clause can be added in Map on the Target Sources page’s vertical view.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |