tag:blogger.com,1999:blog-7520011559741642198.post333289902691780673..comments2021-01-12T02:14:21.650-08:00Comments on Technology & Other Worldly Issues: Odi Load Multiple XML FilesUnknownnoreply@blogger.comBlogger10125tag:blogger.com,1999:blog-7520011559741642198.post-11691117596577043522021-01-12T02:14:21.650-08:002021-01-12T02:14:21.650-08:00Is there no way around the drop and recreate schem...Is there no way around the drop and recreate schemas? like may be using the variable in the XML topology?<br /><br />Im using odi 12c, the latest version, this solution though was nearly 11 years ago, is there is an easier way to load multiple XML files with same structure into the same target?O_allthewaynoreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-8388888830550609172016-12-27T07:04:13.545-08:002016-12-27T07:04:13.545-08:00you have not provided any detail of the error you ...you have not provided any detail of the error you are receiving. <br />Whenver, you need help, you need to provide the exact version numbers,<br />source data, target structure, commands that you are issuing, the error you are getting.<br />Without this information, its like shooting in the dark.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-7814414708249146562016-12-27T05:01:45.214-08:002016-12-27T05:01:45.214-08:00hi experts
i have 64 multipls xml files with sam...hi experts <br /><br />i have 64 multipls xml files with same structure,this xml files loaded in single target table in database,iam trying but its not geeting results so pls help me to solve this issue.multiple xml files to single target tableAnonymoushttps://www.blogger.com/profile/04427057385344211824noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-1781399974821899242016-07-12T09:32:24.596-07:002016-07-12T09:32:24.596-07:00Can anyone tell me the commands to refresh the sch...Can anyone tell me the commands to refresh the schema i.e DROP, CREATE and LOAD. Im new to ODI<br />any help appreciated. Thank youBashttps://www.blogger.com/profile/11731213544760300626noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-71470603246847168332015-02-10T15:07:02.755-08:002015-02-10T15:07:02.755-08:00Thank you! This is my first time working with loa...Thank you! This is my first time working with loading XML Files into SQL tables using ODI and with this I was able to load three sample test files with a matching XML Schema into an Oracle Table.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-76592955158366061602011-09-02T13:23:42.790-07:002011-09-02T13:23:42.790-07:00I got it working, but not exactly using the method...I got it working, but not exactly using the method you describe. It might be my version of ODI (11.1.1.3), but the LOAD FILE command does not work, wrapped in double-quotes as you show.<br /><br />You have to put the double-quotes inside the variable value itself, so that when LOAD FILE interprets the variable, it gets the double-quotes as part of the variable's contents.<br /><br />Also, I had problems using TRUNCATE SCHEMA... I ended up using DROP SCHEMA, followed by a CREATE SCHEMA WITH DTD, followed by a LOAD FILE ON SCHEMA, finally a SET SCHEMA. The Oracle ODI manual specifically states that the LOAD FILE command does NOT set the context to the schema that LOAD FILE loaded into... so you have to follow LOAD FILE with a SET SCHEMA command. Hope that helpsKSandbergFLhttps://www.blogger.com/profile/00666907862837388981noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-84957644237849140572011-09-01T13:51:53.972-07:002011-09-01T13:51:53.972-07:00This is exactly what I need... however, I am havin...This is exactly what I need... however, I am having one small problem. The LOAD FILE command is failing for me on the load of the second file, with an error saying that it cannot save the first file... i'm not sure why it's trying to save the 1st XML file anyway, is there a way to get around this?KSandbergFLhttps://www.blogger.com/profile/00666907862837388981noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-42767416631072286552011-01-26T10:26:36.662-08:002011-01-26T10:26:36.662-08:00Hi Ankit,
I am new to odi and i am still facing s...Hi Ankit,<br /><br />I am new to odi and i am still facing some issues could you please clarify certain points as a am stuck badly<br />We are performing DB to XML transformation and an intermediate staging table is used.<br />IKM – IKM SQL to SQL incremental update<br />CKM – CKM SQL<br />LKM – LKM SQL to SQL<br />1. Work table C$_ is created both for staging area and target XML physical schema.<br />2. SNP_CHECK_TAB is created on the target XML schema. Shouldn't it have been created on the staging area.<br />3. I am facing issues because of above two points Since after an unsuccessful run and during re-run the work table and check table of target xml schema are first not getting deleted with the message that the table doesn't exist and in the next step when it tries to create a new table the step fails saying the table already exists. I have tried using the DOD (drop on disconnect property during xml data server creation but i am still facing the issue).<br />thanksUnknownhttps://www.blogger.com/profile/17167378916226544807noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-32453142638849321222010-10-26T11:39:48.697-07:002010-10-26T11:39:48.697-07:00Thanks for the comment Craig.
We have large XML fi...Thanks for the comment Craig.<br />We have large XML files, sometimes over 100MB and concatenating hundreds of them blows the agent's memory. Hence, we prefer the loop approach.<br /><br />Other than that, I have used odixmlconcat to concatenate upto 12000 xml files (3-5 KB each) successfully. And it works just perfect.Ankit Jainhttps://www.blogger.com/profile/03901964487407781871noreply@blogger.comtag:blogger.com,1999:blog-7520011559741642198.post-30796897038945833992010-10-17T10:01:42.780-07:002010-10-17T10:01:42.780-07:00I know this was some time ago, but I'd like to...I know this was some time ago, but I'd like to point you to the ODIXMLCONCAT tool at http://download.oracle.com/docs/cd/E14571_01/integrate.1111/e12643/appendix_a.htm#CEGDHGHF<br />This allows you to append multiple XML files together (sorting out the inconsistencies that would introduce) so that you run one import/interface rather than looping through many.Badgerhttps://www.blogger.com/profile/18335320549848208337noreply@blogger.com