DSXchange

Can Info Analyzer process unicode data files like Chinese,Spanish etc. How do we know whether Info Anlayzer installation is non -unicode or unicode installation. If we check in DataStage that DataStage installation is non-unicode would it apply the same to Info Analyzer as everything is a part of In...

There is a program which is transfering the file I think its transfering it in ascii character set format because when I try to load the TD it changes the properties by default to stated as below.

I am trying to read a file which was transfered from mainframes machine to the datastage sever in.txt format.The file is in ebcdic format,though I am able to read majority of the columns properly some of the columns data are not displayed properly.In the format tab this is what I have set DataFormat...

Go to DataStage Director under the Job tab Click on cleanup process locate your job process id and kill it.Then go to the job tab again and click on clear status file which will reset your job status and would remove the present running status.

Cool.

Thanks a lot Julio for all the help and your time.

Appreciate it very much.

I got it but going back to our original question,if match frequency is calculated in first job by writing to a file and later using that file in next job as one of the input to Unduplicate match stage.As the file wont get created as match frequency generates zero records how do we do that.Do you thi...

Here is more info from log on it Using Match specifcation ================ S_Customer_Intput,0: Import complete; 27167 records imported successfully, 0 rejected. Match_Frequency_85,0: Field export complete. 1 records converted successfully, 0 rejected. Match_Frequency_85,0: Field import complete; 1 ...

I removed the frequency stage & it writes to the file.In match frequency stage when I check dont use match specifcation it works but when I specify the match specifcation stage it doesn't work.In the match specifcation stage I just blocked for one column.I tested it with Unduplicate match and it...

All the below options are correct I checked it.I gave the max frequency as 1000,mapped the input fields to output and the file names are correct. Seq----> Transformer--->Frequency -----> Seq File. When you say post your job design do you mean the high level design or dsx.If it is high level design t...

All the below options are correct I checked it.I gave the max frequency as 1000,mapped the input fields to output and the file names are correct. Seq----> Transformer--->Frequency -----> Seq File. When you say post your job design do you mean the high level design or dsx.If it is high level design t...

Its working if I get the frequency in a job into text file and then use that in the Unduplicate Match job as input to it.Thats a good thought. But I am running into a strange problem,if I copy all the stages from Unduplicate match job and remove stages not required & capture frequency it works b...

Write three queries in 3 database stages and output them to sequential file with file name as <youropfilename>.xls and in properties tab specify the delimter as tab from the listed drop down in the window.DO the same for other 2 files too.

I am blocking on two columns which are in a good format.I am also using data frequency stage because it needs to be passed as an input to Unduplicate stage for getting duplicates with an option being used as Unduplicate Independent in match specification.The no of nodes is also one. The same job run...

I created one od the Qualitystage job which uses unduplicate match.If the job is run for small chunks of data like 1000 records it works well but if I run the same job for large chunks of data like 10000 it keeps on running forever hours.Is there any workaround or solution by which we can make it ru...

I found the problem,when you run the query and in the where clause condition s if a column=job parameter and the job parameter is an empty string it aborts. Example-: select empno,ename from emp where empno in (#ENO#) where ENO is a job parameter and its value is ('123','') then as empty string '' i...