Hi,
We are on BW 3.5 flow and facing one issue related to Multiple object Id's . When we extract the Master data from HR we are getting 2 records with same object id one record is delimited to old date and another one is active one.
I just want to know how to extract only one active record in BW 3.5 i know that there are some option like - handle duplicate record option available in BI.
Please help me to get this solved.
Thanks
Ram
Request clarification before answering.
Hi,
This is a standard functionality that it brings the start date & end date of course . That means it stores time dependent master data .
But still if you want to store the active one , you have to write a start routine where you have to delete those records from SOURCE_PACKAGE where the current system date does not fall between the Fields : BEGDA & ENDDA .
After writing this code the system will send ahead only those records for which the current date falls between BEGDA & ENDDA i.e the active records into the master data .
Regards,
Ashutosh Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.