DSXchange

Thanks Chulett for quick response. This process we are implementing first time, so no scripts are existing. Right now we are working on Windows so need to find a way to ftp XML files to datastage server from remote server. Once all the XML files are on Local server then I think need to use XML input...

ArndW wrote:What is your source data type, are you doing an implicit conversion to float in the transform stage?

Source datatype is Decimal and by using decode function changed to varchar and done decimal converion in transform stage

Hi, while loading the data in to sql server I am facing the below issue: Input dataset values are 3.4455, 55.667, 333.44445 In sql server database it is loading like : 3.4400012, 55.6670122, 333.4444499999 But I need the o/p like: 3.44, 55.66,333.44 i.e i need the o/p precision 2 decimals. And the d...

Thanks Chulett for your help.It worked out.

Can we clear all acential registory entries at a time?It is quite hectic
to search and delete hundreds of entries.

Thanks once again.

Hello All, I have one of the tricky requirement in my project. This requirement is basically to handle the Yield to Price conversion . The old system handles this in MSExcel(using macros),and MS Excel has one in built function to handle Yeild to Price conversion. But now the requirement is to handle...

Thanks Chulet for the reply.

I could see only one entry REG_SZ in path
C:\Program Files\Ascential\Datastage 7.5.1\vmdsrpos.dll.

Is this one one want to clear off and after or before uninstall?

Thanks

Hi DSXians, When i click on merge stage in DS designer it hangs up.Later i have to stop the process.No issues with any other stages.I reinstalled the ds client after removing the source directory it previously installed,but of no use. But one more suggession in dsxchange is to clear off registory en...

Resolved.. I designed a seperate job and sorted it on a Key col and then loaded it to the Target oracle table..all this was done in Sequential Mode and I set the Oracle Row Commit to 1..this inserted all the records till the one which was the Culprit.. Then I went back to the Src Table and sorted it...

Since the Src Col data (dates) is in String format to be converted to Timestamp for target table, I guess it will not help to use IsValid() function

Before it aborts it throws this warning

APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may have been lost

Hi, I have src cols having dates as 'YYMMDD' as Varchar2(6) in an Oracle table. I am trying to convert these using StringToTimestamp(lnk.ColName : ' 00:00:00',"%2000yy%mm%dd %hh:%nn:%ss") (Defaulting Century as 2000) to write to another Oracle table. (Proper Null handling done) We have 24 ...

eostic wrote:What are you "doing" with the XML after you get it?

We are writing to RDBMS.

Thanks Ernie/lstsaur.

Hi I have a requirement like below. Can anyone help on this. We have two columns like specified below. Column A Column B X1 10 X1 20 X2 22 X2 32 . . . ' . . We need output like specified below. X1 10;20 X2 22;32 . . . Could anypne please help me on this issue Thanks in Advance

Hi All,
Does any body having particular experience about limitation of DataStage to process XMS?
This might be generalized question, but we are exploring different options to process XML data.
I searched thru forums but couldnt find proper information.

Thanks for your time.