Dear All,
I would like to get the rows with each and every dates between start date and end date and fetch to my datawarehouse. My source table contains only start date and end date where my target table should store with specific dates which between comming record start date and end date.
Do you think it can be done in datastage job??? If yes, may I know how to do it?
Curretly I cann't find the way to do it
Thank u,
ICE
want to get the dates between start date and end date
Moderators: chulett, rschirm, roy
There are a couple of approaches possible. One would be to have a time dimension where you can SELECT all records between two dates and thus use a lookup or join in your job. Another option would be to write a DS/BASIC function which returns a list of dates. Neither is exceptionally difficult to do.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Dear Armdw,
Yeah. I have time dimension. But date between start date and end date will be more than 1 rows and I don't know how to get the between dates. I cann't consider how to map between date from date dimension with my startdate and enddate . If I reference with startdate it will only get 1 day. Right?
Is there any detail steps please???
Thank u for your time,
ICE
Yeah. I have time dimension. But date between start date and end date will be more than 1 rows and I don't know how to get the between dates. I cann't consider how to map between date from date dimension with my startdate and enddate . If I reference with startdate it will only get 1 day. Right?
Is there any detail steps please???
Thank u for your time,
ICE
ArndW wrote:There are a couple of approaches possible. One would be to have a time dimension where you can SELECT all records between two dates and thus use a lookup or join in your job. Another option would be t ...
Use a left outer join between your time dimension and data.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm