I have a output to achieve for which my experience in datastage is not helping much. I request if anyone can help me.
My Input
-----------
Code: Select all
FILE 1
PID ORG DC Stdate EndDate Price
P1 10 1 1-MAR-10 30-OCT-10 100
FILE 2
PID ORG DC Stdate EndDate Price
P1 10 1 22-MAR-10 1-OCT-10 98
-----------------------------
Code: Select all
PID ORG DC Stdate EndDate Price
P1 10 1 1-MAR-10 21-MAR-10 100
P1 10 1 22-MAR-10 01-OCT-10 98
P1 10 1 2-OCT-10 30-OCT-10 100
Rules here are.
The records in the second file should always get priority. The first file start and end date and price should adjust according to a record in the second file. Please note that in my output, the dates/period of price is closing before the start date in second file
The keys of the table / file are PID, ORG & DC
Any ideas to do this .....