DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 129 matches
Author Message
 Topic: Truncate and Load in Oracle Stage
bikan

Replies: 13
Views: 8038

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 17, 2010 5:49 am   Subject: Truncate and Load in Oracle Stage
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.

Than ...
 Topic: Truncate and Load in Oracle Stage
bikan

Replies: 13
Views: 8038

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 17, 2010 5:19 am   Subject: Truncate and Load 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 oracle stage.
 Topic: Truncate and Load in Oracle Stage
bikan

Replies: 13
Views: 8038

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 17, 2010 5:17 am   Subject: Truncate and Load 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.
 Topic: Truncate and Load in Oracle Stage
bikan

Replies: 13
Views: 8038

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 17, 2010 4:47 am   Subject: Truncate and Load in Oracle Stage
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 opt ...
Resolved
 Topic: How to run a single job in multy instance in DS 7X EE.
bikan

Replies: 1
Views: 1834

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 11, 2010 11:42 pm   Subject: How to run a single job in multy instance in DS 7X EE.
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 ?
 Topic: XML Output stage
bikan

Replies: 0
Views: 1081

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 16, 2009 3:16 am   Subject: XML Output stage
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 s ...
Resolved
 Topic: XML Output
bikan

Replies: 8
Views: 4349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 24, 2009 5:26 am   Subject: XML Output
Hi All,

Please reply to this question.

Thanks in Advance
Resolved
 Topic: XML Output
bikan

Replies: 8
Views: 4349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 22, 2009 11:04 pm   Subject: XML Output
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 ...
Resolved
 Topic: XML Output
bikan

Replies: 8
Views: 4349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 22, 2009 6:56 am   Subject: XML Output
Hi,

I am getting output as
<Cust>
<Customerno> 11111 </Customerno>
<add1>abcd</add1>
<add2>defg </add2>
<city>xyz, lkmn, abcd, pune</city ...
Resolved
 Topic: XML Output
bikan

Replies: 8
Views: 4349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 22, 2009 6:15 am   Subject: XML Output
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: Xpath Expression..
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> ...
 Topic: XML Input Stage
bikan

Replies: 6
Views: 3621

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 03, 2009 10:18 pm   Subject: XML Input Stage
Which part of this statement is unclear?
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 kn ...
 Topic: XML Input Stage
bikan

Replies: 6
Views: 3621

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 03, 2009 9:54 pm   Subject: XML Input Stage
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 A ...
 Topic: XML Input Stage
bikan

Replies: 6
Views: 3621

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 03, 2009 7:19 am   Subject: XML Input Stage
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Hardware configuration
bikan

Replies: 4
Views: 2159

PostForum: General   Posted: Tue Jun 02, 2009 7:13 am   Subject: Hardware configuration
Agree with you.

But for a planning purpose is it Ok to prepare a machine with the given configuration?
 Topic: Hardware configuration
bikan

Replies: 4
Views: 2159

PostForum: General   Posted: Tue Jun 02, 2009 6:44 am   Subject: Hardware configuration
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 configurat ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours