DSXchange

Hi, I am getting timestamp string (varchar(17) ) with milliseconds. Now using transformer i want to validate whether Timestamp is in correct format with correct value. I am doing this: If IsValid('TimeStamp', CL.crctn_dltn_ts) Then SetNull() Else "2010". But its not validating milliseconds...

Timestamp format %yyyy%mm%dd%hh%nn%ss%SSS is working fine.
Make sure the %SSS and nor %sss.

Thanks to everybody.

Regards
~Nirmal

Hi, I have this input string "20101221101010457" ( varchar(17) ) and i want to insert "." after 14 character in this string using modifier stage. I want the output string as "20101221101010.457" ( including DOT ). I know how to do this using transformer but i dont want ...

But to make this conversion, i need to use transformer.

Can you please tell me how to do the same using modifier?

Still the same error.

EX: At field "exctn_ts": When validating import/export function: "timestamp_format" property value (%yyyy%mm%dd%hh%nn%ss%SSS) is not a valid format.

The only format it takes is ".n" in the end.

Its still giving me the same error.

EX: At field "exctn_ts": When validating import/export function: "timestamp_format" property value (%yyyy%mm%dd%hh%nn%ss%S) is not a valid format.

I am getting this error with this format.

EX: At field "exctn_ts": When validating import/export function: "timestamp_format" property value (%yyyy%mm%dd%hh%nn%ss%SSSSSS) is not a valid format.

I am getting the data in this format: 20101221101010437 So this with format %yyyy%mm%dd%hh%nn%ssn is not working. If i get the data in 20101221101010.437 ( millisecond with dot ) then %yyyy%mm%dd%hh%nn%ss.n is working fine. So i am getting string without dot (Timestamp string of 17 characters ) whic...

Can timestamp be represented in milliseconds in Datastage and What is the format ?

Currently we are using this format for timestamp is: %yyyy%mm%dd%hh%nn%ss

Can i extend it further to check incooperate milliseconds also ?

Please reply ASAP.

Hi,

Can anybody please tell me how do i convert hexadecimal string to integer/bigint.
Is there any inbuilt function available for this conversion in Datastage?

I am using compress stage to read data from sequential file , compress it and write it to data sets. seq. file ----->Compress Stage---------> dataset But i am getting this error "Program 'compress' was not found in PATH " I donot understand what do i need to include in my path variable ? P...

Thanks Craig,

I am more concerned about the accuracy than Performance.

We can handle the Performance if it gives the correct results on increasing volume of records.

Regards
~Nirmal

Ok, So can you please answer my 2nd question regarding the performance and accuracy?

Will it work correctly for billions of records ?

Regards
~Nirmal

In our table we are having 30 columns and we need to compare all the 30 column of one record with another to determine duplicates and also we are doing almost the same thing to determine the parent child relationship. So it is very cumbersome to every time use all the 30 columns So we are generating...

Hi , I want to use the inbuilt checkSum stage in DS8.1 to generate a unique key. I have couple of question regarding this. 1. It generates the checksum field in Alphanumeric form. Can it generate the checksum field in integer/Bigint ? 2. We are getting 5 billion records a day ( may be more in future...