DSXchange

Hi All,

I have source datatype from oracle as 'date'. I am reading this as timestamp.

I have another source from different table with datatype as 'date' and i am reading this as timestamp.

in ETL transformer, I am using timestamptodate function to convert them to date.

I am trying to achieve this in ETL, if a > b and a<=c then output 'true'

after i use TimestampToDate function i find these values in peek stage for a,b,c

a= 2006-03-24
b=2004-06-07
c=2007-05-24

when i try this in transformer a > b and a<=c, i get null in the output. can someone please suggest. Thanks You.
can

Where are you writing this derivation? What is the datatype of the field/variable where you are writing this expression?

change the data type for all fields to timestamp & check with 'isvalid' condition for 'timestamp', then you can write if then else condition

thx

could be Use Oconv() and ICONV() fuctions after compare that

123gopal wrote:could be Use Oconv() and ICONV() fuctions after compare that

In a parallel job?
After?!!

use the functions ICONV() and OCONV() instead of using timestamp to date in parallel job

123gopal: To echo Ray's question, why? ICONV and OCONV would require the use of a BASIC transformer, potentially affecting performance if this parallel job.

Pavan, can you provide the actual derivations you have written?

Regards,