DSXchange

Hi Everyone, I wanted to see all .isx files imported into fast track. is there any folder I can locate on server side / client side. My objective for looking this information is if some of the assets already imported, I don't want to redo again instead I will append assets which are not there. Pleas...

Hi Everyone,

May I get some information about Mapping Specification in Information Governance Catalog.

how this is beneficial for Data Lineage activities?

I contacted IBM support, they suggested to install patch JR56834.

Patch resolved issue.

I used Connector Migration tool in 11.5 version, migrated the server jobs having ORA OCI stages to Oracle Connector stage. Before migration server job ORA OCI stages property " Prefetch memory setting" value as 5000, but after migration setting in Oracle connector "Prefetch Buffer Siz...

I installed InfoSphere DataStage 9.1.2 on AIX server. We have some issues with Metadata work bench like Leneage reports loading slowly and few other issues. when we contacted IBM support, they mentioned in 11.3 version most of the issues addressed. They also told that I can install 11.3 on a differe...

I am using 8.5. Please see below entries from log. But my concern is reference match job running long. if I can bring down customer dimension data volume then job might complete fast. ------------------------------ Match Pass 1 ------------------------ Number of data input records read = 557537 Numb...

I have a customer dimension data of 8 million records. Expected volume of customer data coming from source is up to 1 million (Delta records). I am doing standardization of customer_master data and incoming source data before match process to find out match records & residual records. Customer d...

We have source data coming in person table , as part of initial load process , I standardized and did unduplicate process to categorize master, duplicate and residual records and finally loaded into customer master table. During incremental load process I am using reference match stage to compare cu...

Thank you Chulette.
You will need to build the file with the actual parameter value included in it .

can you please elaborate on this?

Is there any provision in QualityStage to check valid Email Adress and phone number .

Below are the things that i am looking to check.

email address should to have . and @

Phone number should be in US format (888) 888 8888

I using standardization stage to standardize name and addresses. Below warning message I am getting in director. " Stan_Cust,1: 'ANGELLFAMILYTRUSTPERRYORETZKYSUCCESSOR' exceeds maximum length of 20 for output field MatchPrimaryNamePackKey. The data will be truncated. To prevent this warning, mo...

Thank you very much for the response. Our requirement is to compare new data against existing data. As per your suggestion, I will use the reference match stage. I have one question in choosing reference source input to Reference match stage. In our process I am loading match data and residual data ...

We have customer information in two databases , now I am doing standardization and un duplication using Quality stage And loading into customer master table (this table holds information of customer key , first name , last name etc.. address details we are maintaining in a separate table) During ini...

Thank you very much for responses. Issue resolved by changing match type to Unduplicate independent

Hi BI-RMA,

In first pass I have 5 master records (record type MP) have setids 1,2,4,6 & 9 . these five records came as residual records in 2nd pass with same set id number but record type changed to RA.

my objective is to make one of the record to MP and rest to DA.