Experian Data Quality Community
-
Calling stored procedures with workflow parameters
What problem are you facing? I have a daily process that triggers a stored procedure. This stored procedure should fire some inserts or updates depending of one of the workflow parameters. What impact does this problem have on you/your business? Reprocessing data with hardcoded values instead of dinamic values it is not a…
-
A solution design for validating multiple mixed file schemas
We've recently been working on a solution to the following ask: A user has hundreds of data files with different schemas (different column names, datatypes, numbers of columns etc) Each file has an accompanying metadata file, defining expected attributes (columns, datatypes, primary keys, lengths) We want to be able to…
-
Delimited csv file creation using Export step
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
-
Drop-down picklist instead of free text entry for re-usable workflows
What problem are you facing? Currently re-usable workflows allow a free text input option, which suggests most recent entries. The value entered will be used in processing within the workflow, often relating to fields/data to use for matching etc. This leaves risk of error, if the user enters a typo, which could result in…
-
Experian API call to Execute Workflow
hi, Can someone help me with the JSON request to invoke a workflow through REST API? Below are my workflow specification a. Workflow accepts workflow parameters b Workflow accepts source at execution and its mandatory to give source information.
