Hi,
I am doing same. I am taking upsert strategy and in that i have taken first update then insert and in update query i have written truncate statement.
but still facing the same problem.
Thanks
Search found 128 matches
- Wed Feb 17, 2010 5:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Load in Oracle Stage
- Replies: 13
- Views: 11800
- Wed Feb 17, 2010 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Load in Oracle Stage
- Replies: 13
- Views: 11800
- Wed Feb 17, 2010 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Load in Oracle Stage
- Replies: 13
- Views: 11800
- Wed Feb 17, 2010 4:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Load in Oracle Stage
- Replies: 13
- Views: 11800
Truncate and Load in Oracle Stage
Hi, I am trying to truncate and load a Oracle table using Upsert Strategy. The reason being that I need to capture rejected records after being. So, I am using user-defined insert and update option and am giving the Update and then Insert option. In Update, the query is TRUNCATE TABLE <<TABLE_NAME>>...
- Mon Jan 11, 2010 11:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to run a single job in multy instance in DS 7X EE.
- Replies: 1
- Views: 2561
How to run a single job in multy instance in DS 7X EE.
How to run a single job in multy instance in DS 7X EE.
Is it possible to run a single datastage job to execute for loop ?
Is it possible to run a single datastage job to execute for loop ?
- Thu Jul 16, 2009 3:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 0
- Views: 1714
XML Output stage
Hi All, I have a source metadata as customerid,customername,add1,add2,cost1,cost2 and i have 2 occurence of add1,add2 and cost1,cost2 in my source data file. My data file is like 101,john,abc street,cde street,abd street,dgf street,30,35,60,70 I want output XML file as <ExternalXML> <customerid>101<...
- Wed Jun 24, 2009 5:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 8
- Views: 6337
- Mon Jun 22, 2009 11:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 8
- Views: 6337
Hi All, I am getting same ouput only after including one more parent i.e /Cust/add/add1/text() then also i am not getting right answer. Please help me. I am getting output as <Cust> <Customerno> 11111 </Customerno> <add> <add1>abcd</add1> <add2>defg </add2> <city>xyz, lkmn, abcd, pune</city> </add> ...
- Mon Jun 22, 2009 6:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 8
- Views: 6337
- Mon Jun 22, 2009 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 8
- Views: 6337
XML Output
Hi All, I have a source file like Metadata--custno,add1,add2,city,add1,add2,city,amount Data file---11111,abcd,defg,xyz,lkmn,abcd,pune,1000. I want output as <Cust> <Customerno> 11111 </Customerno> <add1>abcd</add1> <add2>defg</add2> <city>xyz</city> <add1>lkmn</add1> <add2>abcd</add2> <city>pune</c...
- Wed Jun 03, 2009 10:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 6
- Views: 5045
- Wed Jun 03, 2009 9:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 6
- Views: 5045
I'm not in a position to check and don't remember the details, but I recall about a year ago we had issues with XML namespace definitions and installed an IBM patch that addressed the problem. Hi ArndW Thanks for your response... Can u elaborate on the details about IBM patch or location of all the...
- Wed Jun 03, 2009 7:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 6
- Views: 5045
XML Input Stage
Hi All, My jobs looks like External Source ===> XML input stage ===> output file I am not getting any warning or fatal error in director then also data is not getting generated in output file. If i am adding namespace declaration and keeping their ref value in xpath expression then job is running w/...
- Tue Jun 02, 2009 7:13 am
- Forum: General
- Topic: Hardware configuration
- Replies: 4
- Views: 3343
- Tue Jun 02, 2009 6:44 am
- Forum: General
- Topic: Hardware configuration
- Replies: 4
- Views: 3343
Hardware configuration
Hi All, We are planning to load 10 to 12 Million record per night. I'm planning to have below Server configuration. Pls let me know will suit my requirement? What should be the standard configuratio for loading 10 to 12 million records overnight? 4 CPU 4 GB RAM 1 GB per CPU 1 TB Hard Disk .5TB Scrat...