DSXchange

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

We know this error but we wanted to know why it is coming and to get rid of this error.
We want to perform truncate and load option in oracle stage.

We know this error but we wanted to know why it is coming and to get rid of this error.
We want to perform truncate and load option in orcale 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>>...

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 ?

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<...

Hi All,

Please reply to this question.

Thanks in Advance

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> ...

Hi, I am getting output as <Cust> <Customerno> 11111 </Customerno> <add1>abcd</add1> <add2>defg </add2> <city>xyz, lkmn, abcd, pune</city> <amount>1000</amount> </Cust> Means it is not taking second record as new line. Thanks Murari

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...

ray.wurlod wrote:Which part of this statement is unclear?

arndw wrote:I'm not in a position to check and don't remember the details

Hi..

Actaully i dont know abt the patch available in IBM for XML..
Thats why i wanted to know what does "installed an IBM patch that addressed the problem".

Thanks

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...

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/...

Agree with you.

But for a planning purpose is it Ok to prepare a machine with the given 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...