Hi,
I want to use an ODI send mail option in procedure when certain condition is met.
for example:
I have one table "Dummy_table" as
| Dummy_table |
|
| PRODUCTID | PRODTYPE | PRODCODE |
| 11111 | A | 11111 |
| 22222 | A | 22222 |
| 33333 | B | 33333 |
| 00000 | A | 00000 |
And a procedure which is trying to insert records in above table. In this procedure i want to add validation and when the validation is true, need to send mail.
Mail to be triggered:
If PRODUCTID already exists in table then do not insert record with same PRODUCTID in table. Instead of that, call an ODI send mail tool from the procedure which is trying to insert duplicate entry.
Let's say my procedure is trying to insert record with PRODUCTID = "22222" . In this case, i dont want an entry to be inserted as it is already present. I want a mail to be triggered saying that this record is already present.
Any help would be highly appreciated.
Thanks in advance.
Shilpa