tag:blogger.com,1999:blog-2809265941856529088.post6011551237284154442..comments2024-03-28T04:43:19.610-05:00Comments on ETL Tech Blog: INFORMATICA REPOSITORY QUERIES - PART IVUnknownnoreply@blogger.comBlogger11125tag:blogger.com,1999:blog-2809265941856529088.post-30247183419694827172021-08-16T20:56:14.255-05:002021-08-16T20:56:14.255-05:00Mua vé máy bay tại Aivivu, tham khảo
ve may bay d...Mua vé máy bay tại Aivivu, tham khảo<br /><br /><a href="https://evaair.biz.vn/ve-may-bay-di-my-eva-air-gia-re-eva6678.html" rel="nofollow">ve may bay di my gia re</a><br /><br /><a href="https://datvere.vn/ve-may-bay-tu-my-ve-viet-nam/" rel="nofollow">vé về việt nam từ mỹ</a><br /><br /><a href="https://vevietnamairline.com/ve-may-bay-tu-duc-ve-viet-nam-9319" rel="nofollow">chuyến bay từ đức về hà nội hôm nay</a><br /><br /><a href="https://vevietnamairline.com/ve-may-bay-tu-nga-ve-viet-nam-9318" rel="nofollow">lịch bay từ moscow đến hà nội</a><br /><br /><a href="https://datvere.vn/ve-may-bay-tu-anh-ve-viet-nam/" rel="nofollow">giá vé máy bay từ anh về việt nam</a><br /><br /><a href="https://vevietnamairline.com/ve-may-bay-tu-phap-ve-viet-nam-9321" rel="nofollow">các chuyến bay từ châu âu về việt nam</a><br /><br /><a href="https://aivivu.com/combo-cach-ly-khach-san-21-ngay-tai-viet-nam-gia-re/" rel="nofollow">khách sạn cách ly ở nha trang</a><br /><br /><a href="https://aivivu.com/ve-may-bay-chuyen-gia-nuoc-ngoai-sang-viet-nam/" rel="nofollow">chi phi ve may bay cho chuyen gia nuoc ngoai</a>Huongkvbhttps://www.blogger.com/profile/12068916950020887577noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-44139658989026711282021-07-28T00:08:19.315-05:002021-07-28T00:08:19.315-05:00mulesoft training
web methods training
business an...<a href="https://www.kitsonlinetrainings.com/course/mulesoft-online-training" rel="nofollow">mulesoft training</a><br /><a href="https://www.kitsonlinetrainings.com/course/web-methods-online-training" rel="nofollow">web methods training</a><br /><a href="https://www.kitsonlinetrainings.com/course/business-analyst-online-training" rel="nofollow">business analyst online training </a><br /><a href="https://www.kitsonlinetrainings.com/course/oracle-adf-online-training-course" rel="nofollow">oracle adf online training </a>KITS Technologieshttps://www.blogger.com/profile/01255736173821596606noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-81289600224848924342021-04-29T21:46:26.947-05:002021-04-29T21:46:26.947-05:00Nice information, this is will helpfull a lot, Tha...<br />Nice information, this is will helpfull a lot, Thank for sharing, Keep do posting i like to follow this <br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica online training</a>sindhujahttps://www.blogger.com/profile/10517986219219378713noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-71216001681544873462020-10-12T01:14:22.715-05:002020-10-12T01:14:22.715-05:00for the Section 14.4 query, i would like to get th...for the Section 14.4 query, i would like to get the PreSql & PostSql details as well. Could you please help measeervadamhttps://www.blogger.com/profile/09117759772765031582noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-13410801780421909062012-12-20T02:52:55.960-06:002012-12-20T02:52:55.960-06:00Hi Ambarish,
I need to know.. QUERY for Sources &...Hi Ambarish,<br />I need to know.. QUERY for Sources & Targets modfied by user and modified time. Also separately for Session,Mapping,Workflow changed time & chnaged by whom.Rajuhttps://www.blogger.com/profile/04983214961226232777noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-6093888568977827982012-08-28T10:39:08.646-05:002012-08-28T10:39:08.646-05:00Hi Ambarish,
Thanks for your reply.
My requiremen...Hi Ambarish,<br />Thanks for your reply.<br /><br />My requirement is how to identify a workflow is scheduled or not?.<br />If a workflow is 'Un-scheduled' then how can i identify?.<br /><br />The above query return the values based on the scheduler type and not return the values are currently it is scheduled or not.<br /><br />If i am un-schedule a workflow then how can i identify thru queries?.<br /><br />Thanks,<br />BhagyaBig Datahttps://www.blogger.com/profile/12949150729957299191noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-18634187901783998482012-08-28T05:53:03.126-05:002012-08-28T05:53:03.126-05:00Hi Bhagya,
Please use below values for RUN_OPTION...Hi Bhagya,<br /><br />Please use below values for RUN_OPTIONS & END_OPTIONS based on your requirement.<br /><br />RUN_OPTIONS <br />The workflow schedule type. Records the following values for each schedule type:<br />1 = Run on demand.<br />2 = Run once.<br />4 = Run every DELTA_VALUE seconds.<br />8 = Customized repeat.<br />16 = Run on Integration Service initialization.<br />18 = Run on Integration Service initialization and run once.<br />20 = Run on Integration Service initialization and every DELTA_VALUE seconds.<br />24 = Run on Integration Service initialization and customized repeat.<br />32 = Run continuously.<br /><br />END_OPTIONS <br />The stop condition option for the workflow schedule type. Records the following values for each stop condition option:<br />0 = End on a date.<br />1 = End after the number of runs stored in RUN_COUNT.<br />2 = Run forever.<br /><br />Thanks,<br />AmbarishAmbarish Aenagandulahttps://www.blogger.com/profile/13316110978079843135noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-90958739364436068872012-08-27T11:23:25.468-05:002012-08-27T11:23:25.468-05:00Hi Ambarish,
Thanks for your reply.
Below query...Hi Ambarish,<br /><br />Thanks for your reply. <br /><br />Below query return only default scheduler and not for 'Customized Repeat' scheduler workflows.<br /><br /><br />1.5 Check Scheduled workflows using queries<br /><br /><br /> SELECT DISTINCT subject_area, workflow_name FROM rep_workflows <br /> WHERE run_options = 8 AND end_options=2 ORDER BY 1; <br /><br /><br />It is not returning all the scheduler workflows.<br /><br />Thanks in advance.<br />BhagyaBig Datahttps://www.blogger.com/profile/12949150729957299191noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-72086339717911927552012-08-07T11:10:55.393-05:002012-08-07T11:10:55.393-05:00Hi Ambarish, Thanks for useful queries!.. However ...Hi Ambarish, Thanks for useful queries!.. However I was looking for a query which would give me details about email ids used in Session Failure/Success Notification. That is "on_success_email" and "on_failure_email" values.<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/11673222213113866439noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-57287534633126894642012-07-29T13:22:39.175-05:002012-07-29T13:22:39.175-05:00yes Bhagya, please refer to 1.4 and 1.5
Thanks,
A...yes Bhagya, please refer to 1.4 and 1.5<br /><br />Thanks,<br />AmbarishAmbarish Aenagandulahttps://www.blogger.com/profile/13316110978079843135noreply@blogger.comtag:blogger.com,1999:blog-2809265941856529088.post-41009234226990963382012-07-24T06:50:00.122-05:002012-07-24T06:50:00.122-05:00Hi Aambarish,
Thanks for your post, could you ple...Hi Aambarish,<br /><br />Thanks for your post, could you please also explain/tell the field name explanation, means, run_options means what type of data it contains like that..... <br /><br />Also, can you please tell me how to find a workflow is scheduled or not?.<br />Also, ur query 1.5, scheduled query,Big Datahttps://www.blogger.com/profile/12949150729957299191noreply@blogger.com