I am trying to transfer data from a HR application, where salaries are recorded in detail, to a Finance application, where only the summary is shown. I want to use a SSIS package to run a script. I want to lookup the values in the HR application. I am seeking advices as I am not familiar with thesyntax to use for lookups and rec.
Thanks
DL
// -
Looking up the values from the HR_2009 app:
*lookup HR_2009
*DIM ENTITY="TOTALCOMPANIES"
*DIM ACCOUNT="HR_SALARIES_TOTAL"
*DIM EMPLOYEE_2009:EMPLOYEE_2009="M_SALARY"
*ENDLOOKUP
// -
Write to FINANCE application
// there are conversion rules based on the department. if the department is 946, then we derive the account
//we always want to write to category NBUDGETV2, HR_LOAD, and NON_INTERCO
//intco dimension does not exists in the HR application
*WHEN lookup(EMPLOYEE_2009)="M_SALARY"
*when datasrc
*is "ALL_FIN"
*WHEN DEPARTMENT
*IS "946"
*WHEN ACCOUNT
*IS "HR_SALARIES_TOTAL"
*REC(ACCOUNT="40360",CATEGORY="NBUDGETV2",DATASRC="HR_LOAD",INTCO="NON_INTERCO")
*ENDWHEN
*endwhen
*ENDWHEN
*ENDWHEN
*commit