tag:blogger.com,1999:blog-1936665928568066047.post2806754320406954647..comments2023-12-27T03:13:34.514-08:00Comments on Radhakrishna Sarma: Informatica 9 LaunchRadhakrishna Sarmahttp://www.blogger.com/profile/15531516106199587979noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-1936665928568066047.post-71189511357633793282022-07-29T01:17:28.524-07:002022-07-29T01:17:28.524-07:00You have lots of great content that is helpful to ...You have lots of great content that is helpful to gain more knowledge. Best wishes.apsu ba 2nd year result 2021-22 name wisehttps://www.timetableresults.com/apsu-ba-2nd-year-result/noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-10688514505281030922022-07-20T00:14:02.586-07:002022-07-20T00:14:02.586-07:00Looking forward to reading more. Great article pos...Looking forward to reading more. Great article post. Thanks Again. Fantastic.ou degree 3rd sem result 2021 name wisehttps://www.timetableresults.com/ou-degree-3rd-sem-results/noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-35052561448347101142017-09-07T05:46:59.944-07:002017-09-07T05:46:59.944-07:00Revanth Technologies is the Best Software Training...<br />Revanth Technologies is the Best Software Training Institute for Java, C#.NET, ASP.NET,<br /><br />Oracle, Testing Tools, Selenium, Android, iPhone in Hyderabad India which provides online<br /><br />training classes. Online Training is given by Real-Time Expert Only.<br /><br />Key features are:<br /><br />1.One to One and group Sessions as per student convenience.<br />2.Techning by Real-Time Experts<br />3.Flexible Timings and etc..<br />4.Customized course content as per student's requirement.<br /><br />Visit Our website for Java Course Content:<br />http://www.http://www.revanthtechnologies.com/java-online-training-from-india.php<br /><br />For more details please contact 9290971883 / 9247461324 or drop a mail to revanthonlinetraining@gmail.com sas-online-traininghttps://www.blogger.com/profile/10707785660660234943noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-40761071672138026152017-04-03T02:56:39.461-07:002017-04-03T02:56:39.461-07:00Great stuff provided by the Admin here… look into ...Great stuff provided by the Admin here… look into this for <a href="http://www.monstercourses.com/courses/data-warehousing/informatica-online-training/" rel="nofollow">informatica online training</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-33963283751118198702013-03-21T09:51:30.865-07:002013-03-21T09:51:30.865-07:00Hi Radhkrishna,
Please share me if you have any h...Hi Radhkrishna,<br /><br />Please share me if you have any handy oracle query to extract following metadata object in PC 8.5.1 repository table.<br /><br /> <br />Folder Name ,<br /><br />Workflow name ,<br /><br />Session name ,<br /><br />Mapping Name ,<br /><br />Source type ,<br /><br />No Of Sources,<br /><br />Target type,<br /><br />No Of Targets,<br /><br />No of Transformations<br /><br />Transformation Name,<br /><br />Thanks,<br />ManasManas Ranjan Pradhanhttps://www.blogger.com/profile/13411481493578258137noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-24569322686339662922012-12-29T09:30:23.731-08:002012-12-29T09:30:23.731-08:00Hi Rk Sir,
I hav one doubt regarding the metadat ...Hi Rk Sir,<br /><br />I hav one doubt regarding the metadat tables..<br /><br />I hav created one user in through admin console. however i did nt get those details in OPB_USERS metadata table..<br /><br />Can u please guide me in this context.<br /><br />Regards<br />SrinivasAnonymoushttps://www.blogger.com/profile/03292478142326065110noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-44042275611410214632012-12-25T17:10:42.915-08:002012-12-25T17:10:42.915-08:00Guru,
I want to see the commands executed in the...Guru,<br /> <br />I want to see the commands executed in the background when I create a user / group / grant privelages, using the adminconsole GUI options. I am sure that every action performed in adminconsole shoots same backgroud command's to completely sucessfuly.<br /> <br />For example : at the time of New Installation of Informatica PowerCenter there is a log create (<br />PowerCenter_8.5.1_InstallLog.log) at the Installation home directory, and all the infasetup / infacmd commands executed during the Installation is recorded in that particular file.<br /> <br />I appreciate all your comments and response, so please...<br /> <br /> <br />Regards,<br />Pitos.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-72570339695251578452012-04-16T19:18:02.942-07:002012-04-16T19:18:02.942-07:00Hi Radha,
I am working on query to get the run ti...Hi Radha,<br /><br />I am working on query to get the run time statistics which gives me folder name,workflow name,session name and transformation wise.<br />I could able to get the data till session level. I am not sure which table has transformation wise execution statistics. <br />I am using these 2 tables for getting Folder,workflow,session name details.<br /><br />REP_SESS_LOG, REP_WORKFLOWS<br /><br />Can you please share the table which has transformation source/ target execution statistics for getting Applied rows, Affected rows, Rejected rows.<br />Thanks in Advance.<br />Arjun.Arjunhttps://www.blogger.com/profile/03562182673621356877noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-40514002419296218292012-04-12T20:47:17.130-07:002012-04-12T20:47:17.130-07:00Hi Sarma,
Could you help out on the below issue,
m...Hi Sarma,<br />Could you help out on the below issue,<br />my stage table is loaded with 72 records and when i ran a mapping from stage to fact ,100 records are loading in fact table.<br /><br />Please suggest.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-11441148665603431462012-04-09T05:37:51.169-07:002012-04-09T05:37:51.169-07:00Hi Radha,
This is Ashok.I observed widget type for...Hi Radha,<br />This is Ashok.I observed widget type for sql transformation and union transformation is 97.is there anyway to identify or distinguish the transformation which is sharing same widget type other than widget name? please help me out your help highly appreciated. Thanks in advance.Marriage Photoshttps://www.blogger.com/profile/17999890194567963639noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-18868010100048658202011-10-17T11:39:11.130-07:002011-10-17T11:39:11.130-07:00Hi Radhakrishna,
I read your blogs on informatica ...Hi Radhakrishna,<br />I read your blogs on informatica blog too, and found them very useful. Thanks for your sharing knowledge. <br />I have one query, hope you may help me out.<br />i want get the all the list of email infromation in email tast and post session success and failuer email. can you please tell me how can i get the information.<br />Thanks in advance.<br /><br />PraveenPraveenb6https://www.blogger.com/profile/10681994861616739917noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-2957513280049381802011-05-10T05:56:19.848-07:002011-05-10T05:56:19.848-07:00Hi,
can this informatica metadata tables can be us...Hi,<br />can this informatica metadata tables can be used in maaping, <br />i m using the infa 8.6.1 cleint, unbale to find any of the metadata objects.<br />how to find this,, can you write down the steps.raghuhttps://www.blogger.com/profile/03060855884280851007noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-70017362333287733852011-01-21T02:11:55.509-08:002011-01-21T02:11:55.509-08:00Hi Sharma,
Can u plz send me the ppts which u tol...Hi Sharma,<br /><br />Can u plz send me the ppts which u told in ur post http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/informatica-architecture-3146745.<br /><br />rvutikonda@gmail.com<br /><br />thanks in advance.<br />RaghavRaghaVhttps://www.blogger.com/profile/03566927497156279040noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-7153045268732673662010-12-27T06:53:17.600-08:002010-12-27T06:53:17.600-08:00Hi Sharma,
Can u plz send me the ppts which u tol...Hi Sharma,<br /><br />Can u plz send me the ppts which u told in ur post http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/informatica-architecture-3146745. <br /><br />to tejasvi26@gmail.comTejasvihttps://www.blogger.com/profile/06301507698743345585noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-21949325535656565472010-03-02T12:15:05.143-08:002010-03-02T12:15:05.143-08:00is there any opening in Credit Suisse Singapore fo...is there any opening in Credit Suisse Singapore for permanent position? please e-mail me to rameshkumar.kannan@gmail.comUnknownhttps://www.blogger.com/profile/13767141392946906584noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-83516630281934646132009-11-16T17:06:50.782-08:002009-11-16T17:06:50.782-08:00Hi Ravz,
Where are the rejected records gett...Hi Ravz,<br /><br /> Where are the rejected records getting stored in the Bad file or in the PMERR* Error logging tables? <br /><br /> If it is the later, then yes, there is a performance impact with that.<br /><br />Cheers<br />Sarma.Radhakrishna Sarmahttps://www.blogger.com/profile/15531516106199587979noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-79700957891240474322009-11-16T08:34:08.211-08:002009-11-16T08:34:08.211-08:00Thanks Sarma!!
I have another query like if we are...Thanks Sarma!!<br />I have another query like if we are having rejected rows in mapping and than we are not handling them as a part of Data quality checks, would it impact our performance. I mean would it be reason for bad performance?Ravzhttps://www.blogger.com/profile/02759694691226757074noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-83622768727813137682009-11-13T01:58:00.039-08:002009-11-13T01:58:00.039-08:00Hi Ravz,
Joining the tables in SQL qualifier...Hi Ravz,<br /><br /> Joining the tables in SQL qualifier is just an alternative method. We can not really say if it performs better. Many times database is able to handle the joins effectively that the lookup. You can try to place the lookups in the SQL override and see if that works. In most cases, "yes" it should perform better. Also you will not have cache concentions if you use SQL override.<br /><br />Cheers<br />Sarma.Radhakrishna Sarmahttps://www.blogger.com/profile/15531516106199587979noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-80575110114919239282009-11-13T01:54:08.645-08:002009-11-13T01:54:08.645-08:00Thanks pkurra and Sarma, I understood the tuning f...Thanks pkurra and Sarma, I understood the tuning for lookup. But I wanted to ask that whether joining tables in Source Qualifier itself would improve the performance or not?Ravzhttps://www.blogger.com/profile/02759694691226757074noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-18253355135635847452009-11-12T18:45:32.676-08:002009-11-12T18:45:32.676-08:00Hi Ravz,
Apart from what pkurra has suggeste...Hi Ravz,<br /><br /> Apart from what pkurra has suggested, you can just have a look at this other article on lookups which tells you some other ways to handle it. For a specific solution to the problem, I can not suggest until I see the mapping.<br /><br />Cheers<br />Sarma.Radhakrishna Sarmahttps://www.blogger.com/profile/15531516106199587979noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-2188579406350375332009-11-12T06:37:30.972-08:002009-11-12T06:37:30.972-08:00Ravz,
You can consider some of the below suggesti...Ravz,<br /><br />You can consider some of the below suggestions.<br />1. Try to create the right indexes if the lookup sql's are taking lot of time.<br />2. In Config Object tab in session properties try setting the below 2 properties<br />"Additional Concurrent Pipelines for Lookup Cache Creation" (increase the thread count)<br />"Pre-build lookup cache" (set to always allowed).pkurranoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-62877692436823329032009-11-12T02:30:45.417-08:002009-11-12T02:30:45.417-08:00Hi Sarma,
This is related to one existing mapping ...Hi Sarma,<br />This is related to one existing mapping here in my client's repository. This mapping is taking great amount of time and we want to tune it. We noticed that mapping is having great number of Lookup transformations. So much of the time is spent in creating the cache for these transformations. We can have lookup on most of these tables by joining in the SQ itself. But it will also make our query run for greater time. Would this join in SQL Override improve the performance. <br />Data in Source: around 1.5 million<br />Data in lookup tables: around 0.8 million(There are around 8 such Lookup transformations all having nearly same number of rows).<br /><br />Please suggest!!Ravzhttps://www.blogger.com/profile/02759694691226757074noreply@blogger.com