DSXchange

Hi, You can use head and tail stages to get the first and last records and combine both of them with funnel. Thanks Venkat hi, i m facing a problem with sequential file. i have a source file with header,footer and detail records.header will be the first record and footer will be the last record ,in ...

I tried StringToTimeStamp('1900-01-01 00:00:00','%yyyy-%mm%-dd %hh:%nn:%ss') in the derivation of that column. I am getting the following fatal error , APT_CombinedOperatorController,0: Unrecognized timestamp format identifier: %45 APT_CombinedOperatorController,0: Caught exception from runLocally()...

I tried StringToTimeStamp('1900-01-01 00:00:00','%yyyy-%mm%-dd %hh:%nn:%ss') in the derivation of that column. I am getting the following fatal error , APT_CombinedOperatorController,0: Unrecognized timestamp format identifier: %45 APT_CombinedOperatorController,0: Caught exception from runLocally()...

I added column "PROCESSTIMESTAMP_MOD" data type char(10) in the output of the transformer, after that in the modify stage ( Processtimestamp_mod as input (char(10)) and processtimestamp as output, data type "TimeStamp (38) applied stringtoTimestamp function, but i got the following er...

I am adding this timestamp filed to output link of transformer. datatype timestamp 38. In the transformer, if I give default value 0 in the derivation, its giving an error saying that, invalid conversion from int8 to timestamp.

Can anybody help me?