Experian Data Management Community Forum

Discussion List

• 
  Custom date of birth - Matching

  Hi, As part of our matching process we break date of birth into day / month and year and then have …

  Accepted Answer stevenmckinnon 86 views 5 comments 0 points Most recent by stevenmckinnon November 2019General
• 
  How can we connect to a view in SQL Schema using JDBC connection

  I am able to connect to table and see the columns using JDBC connection. How can I check the views …

  Accepted Answer Raj2019 29 views 2 comments 0 points Most recent by Raj2019 November 2019General
• 
  Extracting the country from an unstructured address using a lookup list of countries

  The problem that you may need to solve is that you have data that is effectively a contiguous strin…

  Clinton Jones 103 views 10 comments 2 points Most recent by Nigel Light October 2019Data Studio best practices
• 
  Accesing data from quick sense files

  Hi everyone, I'm new in data aperture and I have a client who calculates KPIs in a quick sense repo…

  Answered Alfredo Monasi 15 views 1 comment 0 points Most recent by Clinton Jones October 2019General
• 
  Cross-system and cross-table relationship discovery automation

  In our customer cases data quality issues are often cross-system inconsistencies. Technically, cust…

  Accepted Answer Sami Laine 32 views 1 comment 1 point Most recent by Clinton Jones October 2019General
• 
  Sequence count

  Hi, I can't find a sequence count in Aperture - is there one planned in Version 2.x? Nige

  Answered Nigel Light 25 views 3 comments 0 points Most recent by Clinton Jones October 2019General
• 
  Data Studio and MDM

  It sometimes gets asked how we co-exist with an MDM system. We have many customers using Data Studi…

  Steve Farr 64 views 4 comments 4 points Most recent by Clinton Jones October 2019Data Studio best practices
• 
  Use of SQL to refine source data prior to loading into Aperture

  Hi, I was just wondering whether other users would find a Pandora-like feature to pre-filter prior …

  Nigel Light 49 views 9 comments 2 points Most recent by Nigel Light October 2019General
• 
  Connecting to a SAP HANA database using Data Studio v1.6.1

  From the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database…

  Henry Simms 51 views 0 comments 2 points Started by Henry Simms October 2019 Data Studio best practices
• 
  Handling Gmail email addresses for duplicate identification

  The problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…

  Akshay Davis 72 views 2 comments 3 points Most recent by Henry Simms October 2019Data Studio best practices
• 
  Column Exceeds maximum allowed ?

  Anyone any ideas ? I was getting the problem on the postcode column so ran a length check and restr…

  Accepted Answer stevenmckinnon 72 views 13 comments 1 point Most recent by Henry Simms October 2019General
• 
  Availability of source file/table metadata

  Hi, We are using Aperture to compare profile statistics from 2 tables from different SQL databases…

  Nigel Light 13 views 2 comments 0 points Most recent by Nigel Light October 2019General
• 
  Purging Logs

  Does anyone else see this in their logs ? Seems strange that the application is constantly purging.…

  Answered stevenmckinnon 41 views 11 comments 0 points Most recent by Clinton Jones October 2019General
• 
  Post Code improvement

  If a UK postcode is listed in format AB123CD AB12CD A12CD How can I strip this out to a normalised …

  Accepted Answer stevenmckinnon 36 views 3 comments 1 point Most recent by Akshay Davis October 2019General
• 
  Is Unique

  I've had a few questions around checking if a value is unique in a column. Voila: https://us.v-cdn.…

  Chris Downer 21 views 2 comments 1 point Most recent by Akshay Davis October 2019Data Studio best practices