tag:blogger.com,1999:blog-9154833686311218941.post1104613127765197227..comments2023-05-21T05:15:07.263-07:00Comments on All About Databases: Informatica : Lookups Versus Outer JoinsNitin Aggarwalhttp://www.blogger.com/profile/10715838206476296982noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-9154833686311218941.post-5771280525421590702010-07-05T20:40:25.759-07:002010-07-05T20:40:25.759-07:00>>One of task SDE_ORA_PayrollFact failed bec...>>One of task SDE_ORA_PayrollFact failed because of index problem. <br /><br />Are you saying that fact staging table has index defined over it. Normally we will not have indexes over FS tables.<br /><br />You definitely need to look at the cause of duplicates. Removing duplicates is just a workaround and not a solution.Nitin Aggarwalhttps://www.blogger.com/profile/10715838206476296982noreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-24620487467570443632010-07-01T02:21:15.407-07:002010-07-01T02:21:15.407-07:00Hi Nitin,
I am running a full ETL for HR R12 execu...Hi Nitin,<br />I am running a full ETL for HR R12 execution plan. One of task SDE_ORA_PayrollFact failed because of index problem. <br />When i checked the underlying table w_payroll_fs, it had more than 1 lakh rows of duplicated records. <br />is it strange? Removing the duplicated records is a good move? or some other problem i have to look at for solving this issue?Parameshwaran Venkataramanhttps://www.blogger.com/profile/09595228760962787569noreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-28859536891143043642010-01-20T09:03:50.787-08:002010-01-20T09:03:50.787-08:00Hi Nitin,
Iam facing the same problem. unable to ...Hi Nitin, <br />Iam facing the same problem. unable to see russian characters after loading. Iam reading the data from flat file and trying to place in ware house tables. <br />The data is not in correct format. <br />When i seen the file in my system able to see characters perectly, but when i seen same characters in Unix server it is different. please help me to resolve..Kishore........ :-)https://www.blogger.com/profile/09185344818008887577noreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-90267079037063242572009-11-30T00:28:59.412-08:002009-11-30T00:28:59.412-08:00Hi,
What type of join is performed in lookup tran...Hi,<br /><br />What type of join is performed in lookup transformation?<br /><br />Thnks<br />AbhiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-32567610018375173752009-04-02T00:22:00.000-07:002009-04-02T00:22:00.000-07:00King, we can use left/right outer join depending o...King, <BR/><BR/>we can use left/right outer join depending on how you join the parent table and dimension. I found left join more convenient to use. I do not think we can use full outer join as it will give the wrong results.<BR/>Also note that outer joins are more effective in 10G compared to 9G. This is because of the improved execution plan based on "HASH JOIN RIGHT OUTER". I have another post which explains this.<BR/>http://dbcrusade.blogspot.com/2008/01/oracle-hash-join-right-outer.htmlNitin Aggarwalhttps://www.blogger.com/profile/10715838206476296982noreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-77237461615968734142009-04-02T00:02:00.000-07:002009-04-02T00:02:00.000-07:00Thank you this was very much Useful.instead of loo...Thank you this was very much Useful.<BR/><BR/><BR/>instead of lookups Left outer join is it the only way. or can we use other outer joins.Unknownhttps://www.blogger.com/profile/03379006897231246667noreply@blogger.com