we have data warehouse setting use oracle 12c , informatica etl. call hourly procedures in informatica workflow. these procedures take more 1 hour various reasons. possible set timeout event generate mail alert @ database level or informatica level terminate current execution , generate mail alert same.
best regards
well... no. , bunch of other features not part of informatica. here external orchestration tool helpful. 1 takes care of file watching , triggering workflows upon file arrival, reports workflow runs long or short, 1 notify in case file expect has not been received , on.
Comments
Post a Comment