DSXchange

We write a DB procedure to profile data and write results into a table, then a Java program will write the data in the table into Excel. For other profiling information,like data value, frequency count, percent, it is easy to produce in DB. For format and data type, there are two many varieties. We ...

Which schema or use is the profile data in?

I can deduce most of the rules from lots of Column Analysis we have done. By coding a DB procedure to generate the Column Analysis and by coding a Java program to write the Column Analysis result from DB tables to Excel, I can have my Column Analysis results in Excel by one-click. It just tries to d...

When running Column Analysis, the report will show data value ,length, data type and other attributes of a column. Now I need to generate the exact same report using DB procedure. 1-1TM991 data type: STRING +091619220895 data type: INT64 32743625244 data type: INT64 What is the complete logic behind...

Hi rjdickson,

This is the command we used to create the DB2 DB:
db2 create db MatchT USING CODESET UTF-8 TERRITORY US PAGESIZE 32768

rjdickson wrote:Hi,

Are you sure you created the Match Designer database as UTF-8 with 32k pagesizes?

Hi rjdickson,

This is the command we used to create the DB2 DB:
db2 create db MatchT USING CODESET UTF-8 TERRITORY US PAGESIZE 32768

rjdickson wrote:Hi,

Are you sure you created the Match Designer database as UTF-8 with 32k pagesizes?

Aha, I'm back. Thanks for all you guys. I've almost got it. Our DBA created a new DB2 DB and added to odbc.ini. I also created an ODBC with the same name on my Windows client. I filled all the field for creating a test environment, clicked 'Updated' and I got the prompt 'Test Enviroment update compl...

Aha, I'm back. Thanks for all you guys. I've almost got it. Our DBA created a new DB2 DB and added to odbc.ini. I also created an ODBC with the same name on my Windows client. I filled all the field for creating a test environment, clicked 'Updated' and I got the prompt 'Test Enviroment update compl...

Still can not figure out what to click to generate the report. We need to COPY the Frequency Distribution to Excel. IA version is 8.0.1.0. <a href="http://www.flickr.com/photos/10494487@N00/6882808426/" title="Column_Analysis"><img src="http://farm8.staticflickr.com/7106/688...

Currently we click columns one by one and select COPY to copy the column analysis result to Excel. Can we export it to file, say a comma delimited text file? Or can we use, like Perl, to pull it from IADB and write to an Excel file?

Thanks!

As we know, when we design matches. We can configure a Test Environment to test our matches on sample data. I have some questions for the ODBC Data Source: 1 Should the ODBC source be on client machine or server? 2 I have create a MySQL ODBC source on my client machine. And I also can see my ODBC so...

When you change the job name, DS will automatically give u a report of Impact Analysis. I am thinking that just as DS can do Impact Analysis, then there should be a shortcut to do the renaming task. Maybe DS should do further. After giving the Impact Analysis, it should prompt a wizard sort of thing...

The scenario is as following: we have a sequence and this sequence invoke several jobs. All these items are in the same folder. Now we need to change the sequence name and the invoked job names to add '_T'. Can we export all the sequence and jobs to a DSX file and replace some strings in the DSX fil...

no other infomation can be provided.

sorry for the misunderstanding.I typed wrong words.It is 'where 1>2' in the update statement to exclude the update.