Hi,
Scenario: I have flat file which loads some data into Hyperion and generates .err file when it finds some kick-outs (ex: some members may not exists in my planning app etc.,) and job completes successfully. Email notification takes place using built-in OdiSendMail utility by attaching .err file
Below is the Requirement and need to achieve using ODI only (do not want to achieve using batch script to check the file size of .err and handle email notifications) .
If no kick-outs ( means, .err file size is empty), .err file shouldn't be attached to email. Only when there are kick-outs (with some errors in .err file) we need to send this file as attachment.
Note: ODI load gets complete successfully even with kick-outs (Means, out of 10 records in the file, if 2 are kick-outs, rest 8 records gets loaded).
Appreciate your thoughts on this.
Thanks,