Loading Data into Oracle partitions based on months
Posted: Tue Mar 08, 2011 4:38 pm
Hi All,
I have a table which is partitoined into 12 partitions based on month, from ETL job I need to load the data into separate partitions based on month coming in my source.
Can any one help me how can we load the data into a particular partition from datastage parallel job?
All JAN data should go into JAN partiton and all FEb data should go to FEB partitin etc.
And also i have a requirement to update records in particular partition from datastage job.
The question here is, How can we specify partitoin number or name in Oracle EE stage in datastage parallel?
I have a table which is partitoined into 12 partitions based on month, from ETL job I need to load the data into separate partitions based on month coming in my source.
Can any one help me how can we load the data into a particular partition from datastage parallel job?
All JAN data should go into JAN partiton and all FEb data should go to FEB partitin etc.
And also i have a requirement to update records in particular partition from datastage job.
The question here is, How can we specify partitoin number or name in Oracle EE stage in datastage parallel?