DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 382 matches
Author Message
 Topic: XML Data formatted
Nagaraj

Replies: 2
Views: 1370

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 15, 2013 2:18 pm   Subject: XML Data formatted
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: File data getting truncated,
I am trying to write data from the webservice to the target sequential file stage in .txt, the content would be XML output from webservices, then i am trying to read the file thru xml input stage, Now ...
Resolved
 Topic: XML Output
Nagaraj

Replies: 4
Views: 1862

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 09, 2013 12:36 pm   Subject: XML Output
Thank you, I output the whole chunk to a sequential file and reprocessed it using XML input stage and parsed the data. But looks like the soap response i see in the UI tool has data which can go to mu ...
Resolved
 Topic: XML Output
Nagaraj

Replies: 4
Views: 1862

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 08, 2013 2:46 pm   Subject: XML Output
Sample output data

Col1 Col2
1 2 3 2012-09-122012-02-042012-06-05
Resolved
 Topic: XML Output
Nagaraj

Replies: 4
Views: 1862

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 08, 2013 2:35 pm   Subject: XML Output
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
WS is outputting 5 rows with suppose 10 columns
The output i get is just one row with each column getting values from 5 rows and this happens for each column.
so column data is getting appended.
...
Resolved
 Topic: Why use orchadmin to delete datasets?
Nagaraj

Replies: 10
Views: 7928

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 16, 2013 2:45 pm   Subject: Why use orchadmin to delete datasets?
Okay if you write to a file path like /a/b/datsetname.ds

the descriptor files usually exists on

/opt/IBM/InformationServer/Server/Datasets/datsetname.ds.userid.hostname..0000.0002.0000.1334.d1 ...
Resolved
 Topic: Why use orchadmin to delete datasets?
Nagaraj

Replies: 10
Views: 7928

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 16, 2013 12:57 pm   Subject: Why use orchadmin to delete datasets?
Adding more to that.....

Dataset is multiple files. They are
a) Descriptor File
b) Data File
c) Control file
d) Header Files
Resolved
 Topic: Why use orchadmin to delete datasets?
Nagaraj

Replies: 10
Views: 7928

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 16, 2013 12:49 pm   Subject: Why use orchadmin to delete datasets?
The normal rm command will only remove the .ds physical files, and it will not remove the descriptor files places in other locations which has the meta data, Ideally if you delete both these files man ...
 Topic: Reject Handling
Nagaraj

Replies: 4
Views: 1798

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2013 12:44 pm   Subject: Reject Handling
One more way to do is with two jobs and use it in Sequence jobs.

1. Process the file and write it to a reject file if there are any rejects.
2. Send to the concerned person thru command notificati ...
 Topic: Reject Handling
Nagaraj

Replies: 4
Views: 1798

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2013 12:34 pm   Subject: Reject Handling
Okay, Add a column X using column generator(with Y value) and append it to the stream and add a TFm to split into two links one which says if the condition is not met and the other one just through p ...
 Topic: Reject Handling
Nagaraj

Replies: 4
Views: 1798

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2013 10:57 am   Subject: Reject Handling
Use a Transformer to split the valid and invalid outputs to two seperate files. or one to a seperate reject file and the other to a target db or whatever target you have.

PS: Should use the busines ...
 Topic: Parallel job reports failure (code 134)
Nagaraj

Replies: 8
Views: 4821

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 01, 2013 8:47 am   Subject: Parallel job reports failure (code 134)
And Also please check column to column mapping and the data types sometimes if there is a completely wrong mapping done, which throws this error abruptly.
 Topic: Advice on joining on 'unexact' match
Nagaraj

Replies: 8
Views: 3664

PostForum: IBM QualityStage   Posted: Wed Jan 30, 2013 8:55 am   Subject: Advice on joining on 'unexact' match
if i have understood it correctly.

Format the ledger system column data in a standard format so that it joins exactly with AR system,

stripping of the extraneous data in a separate column and ...
 Topic: Identify Jobs that load/reads from a particular database
Nagaraj

Replies: 5
Views: 1757

PostForum: General   Posted: Tue Jan 29, 2013 4:14 pm   Subject: Identify Jobs that load/reads from a particular database
Even this works at table level, i need to find whichever jobs on the server either reading or writing to the DB, This has the table name

SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOB ...
 Topic: Identify Jobs that load/reads from a particular database
Nagaraj

Replies: 5
Views: 1757

PostForum: General   Posted: Mon Jan 28, 2013 9:47 am   Subject: Identify Jobs that load/reads from a particular database
Is there any way to find in the designer environment? I tried usually DB object is not stored in the designer, its at table level.
 Topic: Identify Jobs that load/reads from a particular database
Nagaraj

Replies: 5
Views: 1757

PostForum: General   Posted: Fri Jan 25, 2013 3:03 pm   Subject: Identify Jobs that load/reads from a particular database
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: Need Job names
How do i identify the Job Names which are reading/writing from a particular database?
There is Mainatanance going on the one particular database and there are 100's of jobs scheduled on the server, i ...
 

 Jump to:   



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