desing of datastage job issue

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
parsi_cnu
Charter Member
Charter Member
Posts: 43
Joined: Thu Dec 04, 2003 4:26 pm

desing of datastage job issue

Post by parsi_cnu »

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
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Confusing. Please explain in words. Your also maipulating the dates. What needs to be added to what date and on what criteria.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
pradeepleon
Participant
Posts: 32
Joined: Fri Dec 02, 2005 10:44 pm
Location: Chicago,IL

Re: desing of datastage job issue

Post by pradeepleon »

Can you be more clear on this.........
Thanks,
Pradeep

(Ten Hugs And Nine KisseS - THANKS)......is that true?

In GOD we trust,for all others we take cash.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Looks like the date ranges between these intervals is what's required. Is this so?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”