Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Setting up custom Find Duplicates rules@Carolyn asks I would like to set up a custom Find Duplicates - Not sure how to set up Find Duplic…
-
Adding a variable comment as a "call to action" for data quality issues foundThis is an experiment on handling HR data quality issues using a validation workflow in Aperture Da…
-
Specifiy or select non default schema when pulling external source from Azure SQL server using JDBCIn previous versions of Aperture Data Studio is stated that their were bug fixes related to SQL Ser…
-
Updating multiple keys after de-dupGood Morning, I have recently ran a de-duplication process and have a good set of cluster ID's. Wi…
-
De_Dup failingAnyone any ideas ?
-
Data Studio v2.0 - Export JDBC Error 9002Hi We are trying to export data back to database. We have updated the export definition as follows:…
-
Split Column - 2 columnsHi I have a file that has a column for postal address that is in this format. Using V2.0 Data Studi…
-
SSIS and ApertureIs it feasible to embed an aperture task within a scheduled SSIS job? This would be used in the ini…
-
Data Studio V2.0 - External System ConnectionsHi When you set up an External System Connection it will only appear under the workspace you create…
-
AWS database connection issues to Aperture (v1.6.4)Hi, Does anybody have any suggestions why a database can arbitrarily flip-flop between connecting t…
-
Data studio v2.0 - trigger workflowsHi In version 1.6.1 the way to trigger workflows was to setup the yaml file. How do you setup trigg…
-
APIs in Aperture Data Studio v2In v1 there were a number of APIs for the automation of UI as outlined here under the REST API guid…
-
Data Studio v2.0Hi When l have a snapshot at the end of a workflow, if the workflow is 200k or less lines it will …
-
Data Studio v2.0 - Run workflowHi I have built a few complicated workflows …. lots of steps ending with a snapshot - when l run no…
-
Data Studio v2.0 - Administrator password resetHi The administrator password needs to be reset and unfortunately the administrator is unable to ac…
-
Data Studio v2.0 - Run Workflow - Address Validation - Data Studio drops outHi When we are selecting run on workflows it is failing and kicking you out of Data Studio. Only wa…
-
Data Studio V2.0 - taggingHi I have spent a bit of time trying to determine how to do tagging on a file after or during trans…
-
Data Studio v2.0 - collective grouping columnsHi Hopefully this is a simple question. In version 1.6.1 to group columns across all data, you woul…
-
Data Studio v2.0 - Union multiple FilesHi I am loading over 15 data sources and once l format and validate, will need to union them all to…
-
Grouping in V2 and differences with V1if you're working with financial data with Aperture Data Studio, one of the things that you might w…
-
Data Studio v2.0 - transform function Map to TargetHi I will be loading over 15 sources of customer data. To assist with column naming and tagging the…
-
Delta Data Loads - Data Studio version 2.0Hi New to this forum so hope this makes sense We have just gone live with Aperture Data Studio Ver…
-
Reading files without headers - then scheduling the jobHi We would like to use Aperture (currently using v1.6.2) to read a series of files that are sent o…
-
The title field is requiredBody is 1 character too short.
-
Code going missing in a v1.x job?Hi Are any other users experiencing the frustration of sections of code going missing? We (@Pavan …
-
UK Bank Accounts / Sort CodesIs there way to validate a number against the above or does anyone have a list that I can use the c…
-
2020 Global data management researchExperian recently released its annual global data management benchmark report. This year we surveye…
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…
-
Profiling all tables of a sourceHi team, Partner is using Aperture Data Studio to profile sources on client site - so that he can …
-
Data Views - an abstracted view of your data sourcesAn entirely new concept of data views based on datasets is introduced in V2.0. Views enable designe…
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…
-
User Spaces - a way to organize your workAn entirely new concept of user spaces is introduced in V2.0. Spaces enable designers of workflows…
-
Environments - giving your Data Studio installation more flexibility with sandboxesOne of the characteristics of business-critical systems is that they need to be secured in such a w…
-
Democratizing and controlling data access in v2.0Data Studio v2.0 provides a sophisticated and secure architecture for exposing data to the enterpri…
-
Connecting to an SMTP email server that does not require authenticationData Studio lets you configure an SMTP server connection, which can then be used to send email noti…
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Sche…
-
Hello world...🥂 our developers have been hard at work and we are stoked about this new release. Prod your account…
-
Sample DataWe're looking to not deliver sample data with the installer for v2.0. Instead we are looking at usi…
-
Inferring Gender from Title or Honorific and Gender ReversalSometimes it might be useful to determine the gender of a person from their honorific, so for examp…
-
Impact of snapshots on memoryHi, I am using a job that has several input snapshots defined in it, though I only connect 2 of the…
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the REST API…
-
Creating a Blocking Key from more than one Generic StringI want to write my own blocking key, but the data I am working from has several field which are all…
-
Is it possible to 'pull' data from Aperture Data Studio into Excel?Hi, Whilst there is the option to export data from Data Studio into Excel, is it possible to pull d…
-
Is it possible to reuse the result dataset extracted from Datawarehouse?Scenario 1: Once the required dataset is taken from any Datwarehouse, how can we reuse it for analy…
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approac…
-
Partition Values (Dynamic SQL Partition Row Number)A question that's cropped up for a couple of clients recently is how do I segment my data and split…
-
Slow data loadMorning, Last night I created a sample data set that I am going to use to test our de-duplication m…
-
Custom date of birth - MatchingHi, As part of our matching process we break date of birth into day / month and year and then have …
-
How can we connect to a view in SQL Schema using JDBC connectionI am able to connect to table and see the columns using JDBC connection. How can I check the views …
-
Extracting the country from an unstructured address using a lookup list of countriesThe problem that you may need to solve is that you have data that is effectively a contiguous strin…