on 2006 Oct 16 12:20 PM
Hi all
I have a situation here. i need a transfer routine for the following criteria.
i have three infoobjects which are plant, material, customer and date. i have three records for the above. all of em are same except the date since its a change date. i need to build a transfer routine to pick the latest date record and populate the ods.
Thanks in advance
Chris
Hi:
Its not that easy depending on this situation.
Your total records = 400,000
Lets say that you get 10 datapackets with 40,000 records each.
Its very possible that in your group of three records, 2 of them are in datapackage 1 and the third in datapackage2.
Then, the Code that you write in Start Routine will not work because the Start Routine is always processes DataPackage by DataPackage.
Unless youhave more info about how many records, etc, I suggest you have a Staging Area (which means you may need an ODS before your ODS).
I will get back to you if I think of anything else.
Ram C.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Don't need any routine, update the ODS in overwrite mode and youìll gaet anly last value.
Hope it helps.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.