DSXchange

ray.wurlod wrote:The profiling can be automated (through the iaJob command). ...

Dear Ray , thanks for your time and reply.

How does the iajob command looks like ?

We don't create jobs similar to datastage in IA , do we need to use the project name instead is it ?

Thanks very much

Dear Experts Is it possible to automate the Information Analyzer profiling ? For example like DataStage jobs scheduled and run at regular intervals, is it possible to have a similar set up for Information Alalyzer Profiling to produce the reports at regular intervals with out much manual interventio...

Dear Experts

We are producing XML files as target out puts.
How to get the record count of XML file using DataStage ?

Thanks

Dear Experts I have a job designed where it reads the data from Oracle table and had few look ups in the job after that the job writes the out put to a dataset. There are few million records that needs to be processed, during first few minutes after the job starts it shows like it is processing arou...

No idea, because it's not my file. ... I found on the IBM website that it is bogus warning......i am heading in the direction of applying the patch as suggested by IBM in the following link. http://www-01.ibm.com/support/docview.wss?uid=swg1JR32253 Will update this post once i get input from IBM su...

ray.wurlod wrote:0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file? ...

Thanks for the reply Ray, I exactly I should check it ?

Dear Experts I am loading the UTF-8 format flat files in to oracle tables and all the files are loading fine including the special characters except one file. I have the following warning message while loading it. Column_Import_11,0: Invalid character(s) ([x80]) found converting string (code point(s...

Thanks very much every one.......the trick of changing the datatype from String to Ustring worked........

Thanks once again everyone for your valuable time and support......

ray.wurlod wrote:The schema equivalent of NVarChar(k) is ustring[max=k] ...

The data type in the schema file is 'String'. Once asked the question , I was wondering if the string datatype supports the special characters or not ? But not sure what is the equivalent of Nvarchar in schema file ? Any help is much appreicated . Thanks What characteristics are you giving the field...

Any help please..............thanks Dear Experts I had a problem loading the special characters using the oracle enterprise stage. The special characters are loading fine without using the run time column propogation and without using the schema file definitions. I have mentioned the charset value t...

Dear Experts I had a problem loading the special characters using the oracle enterprise stage. The special characters are loading fine without using the run time column propogation and without using the schema file definitions. I have mentioned the charset value to project NLS default value in the s...

Thanks for your suggestions.....will let you know the outcome soon.........

JoshGeorge wrote:Have you tried the MNS and then doing a refernce to the given tables? For spelling mistake correction a soundex matchig might be an easy way.

Dear Experts I have three questions regarding the address cleansing 1) I have been given reference table ( from Postal Department Netherlands) which contains the standard postcodes, streetnames etc. Is it possible to use this reference table in Quality Stage for address standardization , if so how ?...

Hi Ray , Thanks for your time and reply. My problem is not with either Convert or Ereplace functions, but copying the cloud symbol in to datastage transformer stage. I want to write some thing like this..... Convert('☁','xyz',ColName) but I was unable to copy this cloud symbol for conversion......pl...

Dear Experts The source data that I have contains the special character (symbol) ' CLOUD (U+2601) ☁ ' which needs to be replaced with ' xyz' . How should I achieve this ? I am aware of convert function but not sure how to handle this. FYI this cloud is shown as question mark if I view the data . Any...