DSXchange

Hi Pandeesh,
Yes...it is cycle..Please find the code below.

CREATE SEQUENCE CUST
INCREMENT BY 1
START WITH 1
MAXVALUE 999
MINVALUE 1
CYCLE
CACHE 20
ORDER;

Hi Folks,
Can any one help regarding below issue.

I have created db sequence to generate the surrogate key, which includes the start value as 1 and end value as 999.

My question is what will be the next value it will take if src file contains more than 999 records. ie 1000th record.

Regards,
Venkat

Select col1, col2 From dm_LIM Where (code, REF_DT) in (Select code, max(REF_DT) From dm_LIM LIM, dm_syu Where LIM.code= SYU.code And LIM.REF_DT <= SYU.REF_DT) I am not sure which Stage I should use to implement the logic for (Where LIM.code= SYU.code And LIM.REF_DT <= SYU.REF_DT) Here dm_LIM is ur d...

Hi Friends,
Iam using aggregator stage to find the max of one date field, using max(date) with preserve type true as subproperty.. it is working fine,

My question is what is the need of using preserve type property here ..without this job getting aborted... Can you please clarify this.