DSXchange

Hi, I have an issue in expiring the old record ( SCD type2) for me if a record fails on certain lookups then i dont process that particular record. If that record fails for a couple of days and update comes on that record (means the old record as well as this record all are new) so before inserting ...

Hi Siva, Thank you very much, I gave a different format thats why i didnot get initially. one more query is : the input field is a string '12-23-2005' can we convert it into timestamp directly. I tried with stringtotimestamp function.but i got the message as Trns_Validate,0: Caught exception from ru...

Hi, In my Job, while I am converting from string (of length 10) to date and string (of length 10) to timestamp. I gave the condition as -- If it is not a valid date then '0001-01-01' for date and '0001-01-01 00:00:00.000000' for timestamp. But eventhough the input record has a valid date it is givin...

Hi, I am new to Datastage. I have an issue. It would be great If any one help me out. I am getting the date field and time field in two different attributes. how can i Concatinate both the fields so that i can store the timestamp in the target.( i tried out concatinate ( : ) operator in the transfor...