tag:blogger.com,1999:blog-18326923769537978.post6935215533436523333..comments2024-03-28T10:49:57.030+05:30Comments on Learn Informatica Practically : Scenario 11: How to maintain Audit Table for mapping/session/workflow.Anonymoushttp://www.blogger.com/profile/10493234287801937693noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-18326923769537978.post-15661103291118339682018-02-21T16:32:06.100+05:302018-02-21T16:32:06.100+05:30This comment has been removed by the author.Ancy merinahttps://www.blogger.com/profile/10037676500389770195noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-8235073285824414212018-01-09T19:31:58.806+05:302018-01-09T19:31:58.806+05:30I have done this kind of thing for one session as ...I have done this kind of thing for one session as below.<br /><br /> <br /><br />WF----> Session 1------> Assignment Task-------->Sessio1_Audit<br /> Session 2------> Assignment Task-------->Sessio2_Audit<br /> Session 3------> Assignment Task-------->Sessio3_Audit<br /> Session 4------> Assignment Task-------->Sessio4_Audit<br /> Session 5------> Assignment Task-------->Sessio5_Audit<br /> <br /><br />Session1 to 5 - Actual mapping which contains the ETL<br /><br />when I run the workflow all the business session run in parallel and the data is inserted to audit table , but for some of the session the count mismatch when i actually go and run the query for count Mapping Xml analyzer for src to target mappinghttps://www.blogger.com/profile/01996141369428731201noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-53239431209213619012017-07-15T19:25:05.424+05:302017-07-15T19:25:05.424+05:30Hi Harsh , I want to capture the rejected record i...Hi Harsh , I want to capture the rejected record in the audit table with rejection reason in the same mapping. So my record should go to Target which meets the technical validation ( like not null etc ) but which ever fails to meet technical validation should move to audit table in same napping. I am using a router. But can you please guide me how can I implement both your above approach and rejection in the same mappingAnonymoushttps://www.blogger.com/profile/12066622453713162052noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-51266163793000237332016-10-15T00:46:06.767+05:302016-10-15T00:46:06.767+05:30thank u very much ,i'm able to do this correct...thank u very much ,i'm able to do this correctly after reading ur blog ,thank u once again....<br /><br />arun.Anonymoushttps://www.blogger.com/profile/09760438735092501067noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-32442773733546657942016-01-04T16:59:40.802+05:302016-01-04T16:59:40.802+05:30Thanks for the article Harsh. It's really help...Thanks for the article Harsh. It's really helpful. Besides these I also want to fetch the source table and target table. How can I fetch these?<br /><br />Thanks,<br />EshanEshan chttps://www.blogger.com/profile/04033931076826191068noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-40089809394223505172016-01-04T16:58:40.407+05:302016-01-04T16:58:40.407+05:30This comment has been removed by the author.Eshan chttps://www.blogger.com/profile/04033931076826191068noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-64202809920428366812015-09-02T15:35:37.752+05:302015-09-02T15:35:37.752+05:30Very useful post..
Could you also please clarify o...Very useful post..<br />Could you also please clarify on the below scenario which has been already asked by one of the viewers:<br /><br />How do we handle auditing if my WF contains<br />a)- multiple sessions and each session need to be audited. ( thinking of adding multiple audit<br />sessions and assignment tasks after each session, but audit session cant be reusable<br />obviously, and how will we handle WF vars in such case? )<br /><br />Is it possible to log audit by making audit session as reusable.<br /><br />Thanks in Advance.Vijethahttps://www.blogger.com/profile/11880797667441064291noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-19255639110135287722015-08-29T03:37:35.532+05:302015-08-29T03:37:35.532+05:30What are the different status codes that I can get...What are the different status codes that I can get? 103,105 and ?KuchKuchhttps://www.blogger.com/profile/04953278967748348782noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-2620045087826116382015-07-31T09:43:10.046+05:302015-07-31T09:43:10.046+05:30Thanks for the article..its really goodThanks for the article..its really goodsujanahttps://www.blogger.com/profile/17884689032707768027noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-12313988974110903692015-07-05T12:49:34.930+05:302015-07-05T12:49:34.930+05:30Hi Harsh, This is what I was looking for and u hav...Hi Harsh, This is what I was looking for and u have done a tremendous job.<br />I have done the success scenario and it is working fine and loading all the statistics but if I want to make the main session fail and capture the error code and error_msg , in this case the session to capture audit info is failing with error :failed to prepare the task.<br />Please help me with this issue.chintuhttps://www.blogger.com/profile/02927405254775857678noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-12189856006397954012015-06-26T12:55:36.869+05:302015-06-26T12:55:36.869+05:30Hi Harsh,
This the best post ever came across. Gre...Hi Harsh,<br />This the best post ever came across. Great work!<br /><br />I tried the the mapping but have came across an error. Please help me solving the error.<br /><br />MAPPING DBG_21057 column[o_session_name], expression=[]<br />MAPPING DBG_21057 column[o_WORKFLOWNAME], expression=[$PMWorkflowName]<br />MAPPING DBG_21057 column[o_SESSIONSTARTTIME], expression=[02/01/1900 00:00:00.000000000]<br /><br />MAPPING TE_7002 Transformation Parse Fatal Error; transformation stopped...<br />TE_7002 [02/01/1900 00:00:00.000000000]<br />.<br />MAPPING TE_7017 Internal error. Failed to initialize transformation [exp]. Contact Informatica Global Customer Support.<br /><br />mentioned above are few columns. <br /><br />Please guide.<br /><br />Regards<br />SavitaAnonymoushttps://www.blogger.com/profile/00258116051525031927noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-5368507764468280602015-04-23T09:08:28.559+05:302015-04-23T09:08:28.559+05:30Hi, Rajeev
My mistake, It should be Non-Reusable ...Hi, Rajeev<br /><br />My mistake, It should be Non-Reusable session typing mistake I have correct it now. <br /><br />You have create session as Non-Reusable to enable pre/post variable assignment in component tab. <br /><br />If you want to maintain for Reusable session the use Assignment Task hard code your mapping and session name and assign it to workflow variable. <br />There is nothing wrong in this approach also, as Mapping and Session name won't be changed ever. <br /><br />I simply use Non-Reusable to cover post variable assignment option as well while explaining and implementing. <br /><br />Thanks.Anonymoushttps://www.blogger.com/profile/10493234287801937693noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-14600104089249221022015-04-22T20:14:50.995+05:302015-04-22T20:14:50.995+05:30can you please give me some more detail on step 9 ...can you please give me some more detail on step 9 I am trying to use this on original session that is reusable session.<br />i am not able to see Post SessionVariable Assignment enable.<br /><br />please give me some suggestion....<br /><br />or any alternate way to generate session and mapping name in my audit table/file.?<br />thanks in advance<br />Anonymoushttps://www.blogger.com/profile/02444125433107611949noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-64883928820856621502015-04-12T01:30:30.576+05:302015-04-12T01:30:30.576+05:30Really very useful matter thank u soo much Really very useful matter thank u soo much Anonymoushttps://www.blogger.com/profile/18381375822128211264noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-63991691501552348412015-03-03T09:07:44.469+05:302015-03-03T09:07:44.469+05:30Awesome Harsh. Really useful. Thanks again for you...Awesome Harsh. Really useful. Thanks again for your effort to prepare thisSabyasachi Paulhttps://www.blogger.com/profile/14958880400098064469noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-16508237968755884042014-11-20T23:50:36.811+05:302014-11-20T23:50:36.811+05:30Thanks for sharing your knowledge and I appreciate...Thanks for sharing your knowledge and I appreciate the effort you are putting into the blog.<br /><br />Below are some of my doubts<br /><br />1- I don't understand what you are trying to convey in step 9. I think you mean the session we are auditing cannot not be re-usable as it wouldn't allow post session assignment. That takes us to doubt 3c.<br /><br />2- Why do we need to make these WF vars persistent? I don't see them used in next run.<br /><br />3- How do we handle auditing if my WF contains<br /> a)- multiple sessions and each session need to be audited. ( thinking of adding multiple audit<br /> sessions and assignment tasks after each session, but audit session cant be reusable<br /> obviously, and how will we handle WF vars in such case? )<br /><br /> b)- my session (only 1 this time) contains multiple sources and targets, multiple target<br /> load orders. And I want individual source target statistics. I think the values of vars like<br /> $S_FIRST_LAST_REC.TgtSuccessRows would be total of all targets. are there vars for<br /> individual source/target statistics.<br /><br /> c)- how to audit reusable session<br /><br />Eagerly awaiting your response.<br /><br />P.S - thanks for the tip about mapping vars in last example. Puts a lot of things into perspective. :-)Anonymoushttps://www.blogger.com/profile/13106007361909285125noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-49732337478139637812014-10-07T05:26:26.507+05:302014-10-07T05:26:26.507+05:30I haven't tried yet but its look good one. I w...I haven't tried yet but its look good one. I will try today. thanks for sharing examples.Anonymoushttps://www.blogger.com/profile/10142375800210670112noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-4973239784656717772014-07-29T11:00:05.051+05:302014-07-29T11:00:05.051+05:30make sure to disable this option at session level ...make sure to disable this option at session level and under general tab. and run the entire workflow and try to run now.Balaji Gadihttps://www.blogger.com/profile/06828567701137228637noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-73884932347488123432014-07-21T06:52:40.802+05:302014-07-21T06:52:40.802+05:30Thank you for the post Harsh. I am trying to do th...Thank you for the post Harsh. I am trying to do this example. My workflow has the session which loads the data=>assignment=>session[audit]. However the audit session fails with this error."Failed to prepare the task" Can you please advise?Jayahttps://www.blogger.com/profile/07120621649602092742noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-49206616462392864662014-07-18T14:59:03.638+05:302014-07-18T14:59:03.638+05:30The audit session is getting succeeded and no data...The audit session is getting succeeded and no data is being loaded. Please tell me where could be the problem.Balaji Gadihttps://www.blogger.com/profile/06828567701137228637noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-18907119093230811652014-07-03T15:48:12.975+05:302014-07-03T15:48:12.975+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/10493234287801937693noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-41206428577699608912014-07-03T13:58:02.730+05:302014-07-03T13:58:02.730+05:30Excellent rockstar!!God bless u always...Remain sa...Excellent rockstar!!God bless u always...Remain same forever:)poojahttps://www.blogger.com/profile/12600577896255572826noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-1888077978653760232014-06-20T08:42:20.100+05:302014-06-20T08:42:20.100+05:30Thank you Narendra for your valuable comment. It&#...Thank you Narendra for your valuable comment. It's encourage me to move ahead to share more and more. Anonymoushttps://www.blogger.com/profile/10493234287801937693noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-85774428558552636952014-06-20T00:17:08.280+05:302014-06-20T00:17:08.280+05:30This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/08104328139594695527noreply@blogger.comtag:blogger.com,1999:blog-18326923769537978.post-37939714639446748412014-06-20T00:14:35.987+05:302014-06-20T00:14:35.987+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/08104328139594695527noreply@blogger.com