DSXchange

That works fine Ken.Previously i had been trying the other way.

Thanks
Smita

Hi ken

I got the idea but will it have any effect if my timestamp is in this format
Coz i am getting the wrong output after giving the constaraint.Its giving all the rows as the output(Not checking the constraint et all).

Thanks
Smita

Hi All,

Can we compare timestamp data type in the transformer?

For example:

start_dt<=end_ dt<=rnst_dt

All the dates are of Timestamp type and I need to compare date as well as the time.

Can u please help me out!!!

Thanks,
Smita

Hi,

I need to convert timestamp to integer. I am not able to use ICONV. Got an error which is " ICONV not defined ". Is there any other way since it includes date as well as time.

Can anyone please help me out with it.

Thanks.

Hi all, Here i am having a problem with my lookup job. source is sequetial file with seven rows reference lookup is sybase OCI stage with thousands of rows I am doing looup on a single primary key but out of nowhere i am getting this warning Reference lookup generated 1670 rows. Only the last row wa...

Your question is quite unclear. Are you asking how to get the most current row for a series of rows that have a common natural key? Are you asking for SQL, job design help, what? I am looking for job design help not the SQL,I tried to give max(timestamp) in the transformer constraint but it is not ...

Hi all,

Can somebody tell me how to get the maximun of timestamp from a table having multiple entries.I am trying to maintain history.

Thanks Hun
smita