Hi Irene, Each spreadsheet represents data we received from a different customer. I would like to capture its metadata/descriptors such as column names, data types, number of records etc in EDG. As customers use slightly different terminologies, I also need to map the column names to a single schema so I can merge the data for reporting purpose.
On Tuesday, April 7, 2020 at 10:13:21 AM UTC-4, Irene Polikoff wrote: > > Hi Fan Li. > > On Apr 7, 2020, at 7:51 AM, Fan Li <lifa...@gmail.com <javascript:>> > wrote: > > I should have added that the immediate objectives are: > > - Give domain experts a visual tool to create data mapping > - Use SHACL to describe & validate the harmonized data structure > > > > On Tuesday, April 7, 2020 at 7:45:22 AM UTC-4, Fan Li wrote: >> >> Hi TopBraid Community, >> >> I have a use case where I need to map data sources (spreadsheets) of >> different formats into a single schema. I was wondering how I should use >> EDG on the data modeling aspect of this task. >> >> - Should I use "Data Assets" to model each data source? >> >> What kind of information are you planning to import into EDG? Is it some > data in spreadsheets e.g., the actual information about lets say products > or companies? Or do these spreadsheets contain information about data > sources e.g., what datasets you have, what are the fields in each dataset, > how many records in each dataset, etc.? > > It would be useful if you could provide an example. > > >> - Should I use "Crosswalks" for schema mapping? >> - Is there a concrete example I can follow? >> >> Any guidance is appreciated! >> > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to topbrai...@googlegroups.com <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/80a1e323-0d3e-4a1d-bb8b-33898253242a%40googlegroups.com > > <https://groups.google.com/d/msgid/topbraid-users/80a1e323-0d3e-4a1d-bb8b-33898253242a%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/358116ab-b2eb-4a2f-be3f-213c77253725%40googlegroups.com.
