The Source Designer is a wizard that generates metadata for one or more selected tables, based on the physical structure of the table(s).
The Source Designer can be used to specify metadata for any existing table, not just tables used as data sources for ETL jobs.
The Source Designer supports a number of specific data formats that have been licensed for a site. The specific format will often give better results than the generic format, which has not been optimized for particular kinds of data. Use the format that most closely matches your data whenever possible.
The Source Designer is an easy to use wizard interface.
The next step in the implementation of the orion star marketing data mart is to define the source table to be used in the ETL process.
Select Source Designer from the Shortcut bar of the Sas ETL Studio
Select SAS as the metadata import source
Selectto access the Define Tables window.
Selectto access the Select Group window.
Selectto access the Wizard Finish window.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies