DSXchange

Posted: **Fri Apr 27, 2007 8:56 am**

Hi
I had source as
Col1 start_dt end_dt
X 01-01-05 05-02-09

Lookup
Col1 start_dt end_dt
X 01-02-06 03-03-06
X 05-10-06 10-30-06

I want output as

X 01-01-05 01-02-06
X 03-04-06 05-09-06
X 10-31-06 05-02-09

Basically the source had to fill the dates comparing the lookup

Thanks
srinivas.parsi

Posted: **Fri Apr 27, 2007 9:05 am**

Confusing. Please explain in words. Your also maipulating the dates. What needs to be added to what date and on what criteria.

Posted: **Fri Apr 27, 2007 8:08 pm**

Can you be more clear on this.........

Posted: **Fri Apr 27, 2007 9:39 pm**

Looks like the date ranges between these intervals is what's required. Is this so?

DSXchange

desing of datastage job issue

desing of datastage job issue

Re: desing of datastage job issue