Question:
Hi,
Is there a way to update the Key fields of ODS in the start routine, with a different value based on some conditions.Pls respond ASAP.
Answer:
Please clarify what you mean :
* do you want to modify the key fields of records that are not in you load at that time but that are all ready in the active table?
OR
* do you want to modify the key fields of records that are not in the load at that time. (thus a modification of the data_package)?
Answer:
Hi,
Iam looking more at overwriting the existing key fields in the ODS with a value in the data package.
Ideally if we have a row in ODS with key fields A and B and if a row in the data package has A and D as the key fields,based on some condition the row in ODS with A and B as key field should be replaced by the row in the data package with A and D as key field.
Hope Iam clear. PLS HELP!!! ANY IDEA WOULD BE HELPFUL.
Answer:
Ideally if we have a row in ODS with key fields A and B and if a row in the data package has A and D as the key fields,based on some condition the row in ODS with A and B as key field should be replaced by the row in the data package with A and D as key field.
So, basically you want to completely delete row with key A & B,
and create row with A & D.
completely is the key word here ; if that's correct, then just play with 0recordmode in the start routine in order to add one deletion record to the package, with key A & B
Ch