I anycodings_informatica-powercenter assumed, your infa metadata is on anycodings_informatica-powercenter oracle. So on a bad day, anycodings_informatica-powercenter if this takes hours, average value will anycodings_informatica-powercenter be bad but we cant do much here. Now, this value is an estimated figure anycodings_informatica-powercenter and not correct value. Select sysdate + avg_time_in_hr/24 est_time_to_complete from dual Views: 24882: Published: : Author: : Search: table of content. You can use above value as estimated time to completion for that workflow.Select avg(end_time - start_time )*24 avg_time_in_hr, workflow_name First calculate average time the workflow takes to complete for a successful run.Go beyond table stakes with the industry’s most comprehensive, microservices-based, API-driven, and AI-powered enterprise iPaaS. Now, you can get anycodings_informatica-powercenter some logic like other scheduling tool anycodings_informatica-powercenter does. Benefits of Informatica Intelligent Cloud Services. This is a very good question but no one anycodings_informatica-powercenter can answer correctly :) Heres how they explain the tool: This AMP GS parses Informatica metadata which is then used to populate the Talend components. The column anycodings_informatica-powercenter run_status_code shows whether this wf is anycodings_informatica-powercenter running, succeeded, stopped, aborted etc.īut for my Business use case I also need to anycodings_informatica-powercenter report to Business, the estimated time of anycodings_informatica-powercenter completion of this particular work flow.Įxample: If suppose the workflow generally anycodings_informatica-powercenter started at 6:15, then along with this info anycodings_informatica-powercenter that work flow has started I want to convey anycodings_informatica-powercenter it is also estimated to complete at so and anycodings_informatica-powercenter so time.Ĭould you please guide me if you have any anycodings_informatica-powercenter details on how to get this info from anycodings_informatica-powercenter Informatica database. Recently, they developed a tool called AMP GS for ETL Conversion, which can migrate Informatica workflows and mappings to Talend jobs with minimal manual intervention, reducing mapping times by up to 88. I am working with this metadata table anycodings_informatica-powercenter REP_WFLOW_RUN currently from Infra DB, to anycodings_informatica-powercenter get status about workflows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |