Hello
I have this problem :
I have in a table in a database. This table has two columns : a first date ( a beginning date of a period. example 01 Jan 1999) and a last date ( an end date of a period . example 31 March 1999).
And I would in a other base this:
3 rows
01 Jan 1999 31 Jan 1999
01 Feb 1999 28 Feb 1999
01 March 1999 31 March 1999
And I don't know how to make this with datastage.
Can someone help me
P.S. : My database is Oracle 8i
I have this problem :
I have in a table in a database. This table has two columns : a first date ( a beginning date of a period. example 01 Jan 1999) and a last date ( an end date of a period . example 31 March 1999).
And I would in a other base this:
3 rows
01 Jan 1999 31 Jan 1999
01 Feb 1999 28 Feb 1999
01 March 1999 31 March 1999
And I don't know how to make this with datastage.
Can someone help me
P.S. : My database is Oracle 8i