Experian Data Quality Community
-
How to save profiling result as view for multiple table(50+ tables)
I have many tables, i need to run profiling on each of the tables and need to save the results as view. Since i have more number of tables, is there any way to do this altogether, rather then doing the same thing each table one by one.
-
Auto discovery of keys (foreign, primary)
Logging this idea on behalf of @AlanB (feel free to add further commentary) What problem are you facing? We are starting a migration project from a largely undocumented system and need to identify how the various tables relate to one another (e.g. what are the foreign / primary keys, potential joins as well as conducting…
-
Profiling multiple dataset
In the Latest version I see there is an option of using multiple datasets in Profile and use all columns. Is there any documentation how to use it as I can not use multiple dataset in the same Profile Transformation
-
Can I create Interactivity Snapshot when unioning multiple Profiles from different datasets
Hi, I am new to ADS. I want to make a dashboard a single widget, the widget would be the profile results of 2+ different tables To do this I have profiled two tables, and have unioned them. I then take a snapshot of the union. However, when I create a new dataset as part of the snapshot step, I do not have the…
-
Profiling many datasets of different schemas
To profile thousands of datasets easily, you can create a reusable workflow with a replaceable source. However, if each of the datasets have a different schema, you will have to determine what is the most number of columns a dataset can have and use a generic schema with generic column names in your workflow. Assuming your…
