Creating Custom Extract to Fetch Absence Entry Details
SummaryCreating Custom Extract to Fetch Absence Entry Details
Well before we start this post one question which would arise in the mind of many consultants could be:
Why should we go via the Extract Route if we can fetch the details using BI SQL.
Well there are some advantages like:
a) You can handle large volume of data
b) You do not need to build Custom / Complex Bursting Query to deliver the data-file via different channels to different recipients (HCM Extract does this for you behind the scene)
c) We can get the data in HDL Template so if required can be used for HDL Load (this can be done via BI SQL too but then you might need to have good knowledge on SQL)