differences between Start Routine,End Routine & Expert Routine
3,007 views
Skip to first unread message
Devraj
Aug 8, 2011, 7:26:38 AM8/8/11
to Qbex Tech
Start Routine
Definition
The start routine is run at the start of the transformation. The start
routine has a table in the format of the source structure as input and
output parameters. It is used to perform preliminary calculations and
store these in a global data structure or in a table. This structure
or table can be accessed from other routines. You can modify or delete
data in the source_package .
Approach to Scenario
For field routine it will act on each record but in start routine it
will have all the data in source_package . In Start routine we will
have the structure of the source fields. So in this scenario the key
figure is not available in source.
So in Start routine we calculate the total no of days for each record
with its unique key job number and store them in an internal table.
The internal table is global and it can be accessed every where. So we
have to write a field routine for key figure total no of days mapped
with job number. Using this job number we will read the value of key
figure total no of days from internal table and update the result i.e.
total no of days key figure.
End Routine
Definition
An end routine is a routine with a table in the target structure
format as input and output parameters. You can use an end routine to
postprocess data after transformation on a package-by-package basis.
Data is stored in result_package.
Approach to Scenario
End Routine is processed after start routine, mappings, field routines
and finally before the values is transferred to the output. End
routine has the structure of the target and result_package contains
the entire data which finally is the output.
For our scenario we have one to one mapping for all the fields except
total no of days so in result_package it will not have the value for
each record.
So in End Routine we will calculate the key figure value for each
record and modify the result_package and there by the output will also
contain the key figure.
Expert Routine
Definition
An Expert routine is a routine with contains both the source and
target structure. we can use Expert routine if there are not
sufficient functions to perform transformation.
Approach to Scenario
For Expert Routine every things needs to be written using coding. In
simple an expert routine performs all the actions of Start Routine,
Mappings, Field and End Routines.
In Expert Routine we will read from source_package which contains all
the data and update into result_package which should be the output and
when doing we will calculate the key figure total no of days.
Definition
The start routine is run at the start of the transformation. The start
routine has a table in the format of the source structure as input and
output parameters. It is used to perform preliminary calculations and
store these in a global data structure or in a table. This structure
or table can be accessed from other routines. You can modify or delete
data in the source_package .
Approach to Scenario
For field routine it will act on each record but in start routine it
will have all the data in source_package . In Start routine we will
have the structure of the source fields. So in this scenario the key
figure is not available in source.
So in Start routine we calculate the total no of days for each record
with its unique key job number and store them in an internal table.
The internal table is global and it can be accessed every where. So we
have to write a field routine for key figure total no of days mapped
with job number. Using this job number we will read the value of key
figure total no of days from internal table and update the result i.e.
total no of days key figure.
End Routine
Definition
An end routine is a routine with a table in the target structure
format as input and output parameters. You can use an end routine to
postprocess data after transformation on a package-by-package basis.
Data is stored in result_package.
Approach to Scenario
End Routine is processed after start routine, mappings, field routines
and finally before the values is transferred to the output. End
routine has the structure of the target and result_package contains
the entire data which finally is the output.
For our scenario we have one to one mapping for all the fields except
total no of days so in result_package it will not have the value for
each record.
So in End Routine we will calculate the key figure value for each
record and modify the result_package and there by the output will also
contain the key figure.
Expert Routine
Definition
An Expert routine is a routine with contains both the source and
target structure. we can use Expert routine if there are not
sufficient functions to perform transformation.
Approach to Scenario
For Expert Routine every things needs to be written using coding. In
simple an expert routine performs all the actions of Start Routine,
Mappings, Field and End Routines.
In Expert Routine we will read from source_package which contains all
the data and update into result_package which should be the output and
when doing we will calculate the key figure total no of days.
0 new messages