SAP Datasphere - Data Builder types and creation of Tables
There are different artifacts available in the Data Builder as below. Table Graphical View SQL View Entity-Relationship model Analytic model Data Flow Replication Flow Transformation Flow Intelligent Lookup Task Chain Now lets discuss on them in detail. Tables: Column structure of the tables can be defined either manually or by using the existing data as template. These are going to get the information from different source systems like flat file / sap / non-sap and can be filled with data from a CSV file or via a data flow. While creating a table we can define the following: Technical and Business names Data Type Semantic Usage Label Column Primary Keys Default values can be/not null Visibility of the columns We can also delete current data and upload new data from files and share the current table with other spaces. Hierarchies could be created and the generated CSN annotations could be edited in order to make it synchronize with the expecting changes. Lets discuss th...