DSXchange

Please let me know whether there is any .PAT file for countries with WAVES rule.How to create override for those countries.

Hi,
Please let me know how to import metadata for Excel file into DS.
1. Can I import that without converting it to csv.
2.What will be the delimiter for importing a xls doc.

Hi Kemoid,

Plz explain the solution you found for this problem (I have also faced it a couple of times).
1.How did you export the .UCL file
2.How did you import the modified file to incorporate the change.

I had also tried to classification override to solve this, but found the problem remains.

Please let me know how to do standardization of records with CJK characters

I have source column with 'varchar'.From source data is coming to Transformer where I have used StringToUstring(<data.column>,'UTF-16') and in target (FTP Plug-in)I have column defined as 'varchar' with extended property 'Unicode' set.In target I have set NLS map 'UTF-16'. I am getting error like th...

Please let me know how to do matching between data in English and CJK (Chinese,Japanese,Korian) languages.

Is it a good idea to convert both into UTF 16LE & do matching.

Does QS allows matching between such files.

I can not see beyond 'DataStage job that includes a QualityStage stage to invoke the job, plus RTI (SOAP edition) components that allow you to ... '. Plz let me know how RTI (SOAP edition) components can be used here.

Can a Qualitystage 7.5.2 job be run as a service. If yes, how?

While trying to run a job with Multinational Standardize stage, I am getting the following error : Error exec: pid=65596 PRE all done pid=45594 REPEAT all done pid=45598 STN(41468_001):Wed May 9 05:33:09 2007 (MSG_stan.c:7 ; stan.c:525) ERROR: error returned from tkLoad in StanSpecCompile: STN(41468...

If I require to perform data standardization, matching etc for a country that has no built-in rules available in QualityStage (for example Uruguay,Qatar,India so on) then how to do the standardization for that country. Do I need to get the rules for that particular country. If yes, how?

But to read data in two fields 'XYZ,GHT,UJY' and 'IJY' from input data stream """XYZ,GHT,UJY""","""IJY""" (that also contain data like XYZ,GHT,UJY ) what should be the delimiter and quote values.

Hi, While trying to use a Sequential file stage (.CSV file) as input with delimiter 'comma' and Quote 'none', I am facing the following problem : For records like : XYZ,GHT,UJY - the stage reads the input data properly ( three fields with values XYZ,GHT,UJY respectively) However some of the records ...

can anyone plz tell me (preferably with an example) how do we use 'ExecTCL' in Before/After job sub-routine.

I need to read an input sequential file(.csv) after first 5 records.How do I skip those first 5 rows while reading the file.

Please let me know whether I can run my QualityStage jobs in a Datastage parallel job using QS Plug-in.

Is there any other option (apart from plug-in) to invoke Qualitystage job from DataStage parallel job (like executing the QS equivalent command from 'Command stage' in Job Sequencer)