DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 16 matches
Author Message
 Topic: surrogate key generating off numbers
Damonsal

Replies: 1
Views: 1238

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 26, 2015 9:40 am   Subject: surrogate key generating off numbers
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
I am developing a new job to an existing target table. I decided to initialize the seq with max+1 value to skey file and do an update/insert into the table, so created job to load the data to the targ ...
 Topic: generate report for qualitystage jobs on 7.5.2
Damonsal

Replies: 6
Views: 4214

PostForum: IBM QualityStage   Posted: Tue May 19, 2015 5:25 pm   Subject: generate report for qualitystage jobs on 7.5.2
I tried executing the qualitystage job from the back end on Unix Server Since we dont have GUI/Client for qualitystage, it works fine. But it looks like its all scripts which is called....can i copy t ...
 Topic: generate report for qualitystage jobs on 7.5.2
Damonsal

Replies: 6
Views: 4214

PostForum: IBM QualityStage   Posted: Mon May 18, 2015 8:49 pm   Subject: generate report for qualitystage jobs on 7.5.2
Looks like the reports might not reveal the mapping rules of the job.......! need some workaround....! please advice...!
 Topic: generate report for qualitystage jobs on 7.5.2
Damonsal

Replies: 6
Views: 4214

PostForum: IBM QualityStage   Posted: Mon May 18, 2015 8:22 pm   Subject: generate report for qualitystage jobs on 7.5.2
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: Need Job info
Have a requirement to generate a report for a qualitystage job.
Because of the liscensing issue, not able to view the jobs directly, would like workaround this issue by generating a report about thes ...
 Topic: Webservices using DataStage
Damonsal

Replies: 4
Views: 6472

PostForum: Site/Forum   Posted: Fri Dec 26, 2014 2:57 pm   Subject: Webservices using DataStage
Can we have a seperate forum which only focusses on RealTime Data Integration using DataStage Webservice using DataStage tool? these topics get lost in the DataStage Enterprise edition forum......and ...
 Topic: Load data using Webservices
Damonsal

Replies: 0
Views: 1618

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 14, 2014 4:37 pm   Subject: Load data using Webservices
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Design information required.
Hi Folks,

Requirement:

Load the DB table in MDM EBX(This Database is a propietary database format), only way to load this Table would be to call Webservice they provide.

Here is the approa ...
 Topic: merge multiple XML's
Damonsal

Replies: 4
Views: 1933

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 16, 2014 9:54 am   Subject: merge multiple XML's
You have multiple xml, use three stages and funnel it later in your job OR
Load this in each run by calling the same job 3 times or by looping via multi instance method.
 Topic: Datastage warnings with Oracle
Damonsal

Replies: 5
Views: 1892

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 04, 2014 2:05 pm   Subject: Datastage warnings with Oracle
what is you requirement, why you want to do this way ?
 Topic: Importing metadata from wsdl
Damonsal

Replies: 3
Views: 1700

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 23, 2014 1:18 pm   Subject: Importing metadata from wsdl
No webservice runs just fine.

Okay the xpath description doesnt have double underscores which is correct.

Checked both in IN and OUT table defs, both of them have column metadata filled with do ...
Resolved
 Topic: metadata with increased length
Damonsal

Replies: 2
Views: 1483

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 23, 2014 1:14 pm   Subject: metadata with increased length
Thanks for the information.
Resolved
 Topic: metadata with increased length
Damonsal

Replies: 2
Views: 1483

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 20, 2014 2:31 pm   Subject: metadata with increased length
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Tried importing table definiton from oracle db using plug in metadata definitoon and orchestrate definition in datastage version 9.1.

When i load the metadata in the oracle connector target stage ...
 Topic: Importing metadata from wsdl
Damonsal

Replies: 3
Views: 1700

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 20, 2014 2:29 pm   Subject: Importing metadata from wsdl
i am having more than 200 columns and this is version 9.1. has any body faced a similar situation?
 Topic: Importing metadata from wsdl
Damonsal

Replies: 3
Views: 1700

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 16, 2014 8:09 pm   Subject: Importing metadata from wsdl
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Trying to import metadata definition from the WSDL document, all the column names are changing from col_name to col__name, not sure why i am getting two underscores in place of single underscore.
 Topic: target DDL not in order with column metadata
Damonsal

Replies: 3
Views: 1563

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 16, 2014 8:04 pm   Subject: target DDL not in order with column metadata
technically it doesn't matter, but i wanted to create table in a systematic structure, my question is why the connector is not following what order i gave in the target oracle connector stage ?
 Topic: target DDL not in order with column metadata
Damonsal

Replies: 3
Views: 1563

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 16, 2014 10:21 am   Subject: target DDL not in order with column metadata
Column metadata is created in orderly fashion in oracle connector stage, The DDL statement is not following that order.
 

 Jump to:   



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