DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 988 matches
Author Message
Resolved
 Topic: Windows Filtering Platform
gateleys

Replies: 8
Views: 3693

PostForum: General   Posted: Fri Dec 16, 2011 2:27 pm   Subject: Windows Filtering Platform
In your above response, you've mentioned that support from IBM pointed to the fact that you were still pointing to the "Internal User Registry" due to some misses in OK/SAVE clicks. If that were the c ...
Resolved
 Topic: Windows Filtering Platform
gateleys

Replies: 8
Views: 3693

PostForum: General   Posted: Wed Dec 14, 2011 8:52 am   Subject: Windows Filtering Platform
On similar lines, IBM says that if the User Registry in WAS was set to Federated Repository, then you can add the isadmin and wasadmin to the local repository, and hence, be able to authenticate again ...
 Topic: Removing Duplicates : unique situation
gateleys

Replies: 14
Views: 7900

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 27, 2011 1:56 pm   Subject: Removing Duplicates : unique situation
Assuming that your sequential file contains the rows in that order, in the Transformer, create a stage variable where you compare the previous value of the concatenated keys with the current value.
Resolved
 Topic: suppress trailing zero
gateleys

Replies: 5
Views: 2484

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 27, 2011 1:48 pm   Subject: Re: suppress trailing zero
Try:TRIM(YourValue,"0","T")
Here, "T" implies Trailing.
 Topic: DB Sequence and State file
gateleys

Replies: 4
Views: 1957

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 27, 2011 1:44 pm   Subject: DB Sequence and State file
If your process is the only one that will ever load the table in question then state file should be ok. If there is a chance that other applications may start entering data, then a db sequence object ...
 Topic: Unable to Import XML Table Definations
gateleys

Replies: 3
Views: 3114

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Apr 27, 2011 12:13 pm   Subject: Re: Unable to Import XML Table Definations
I am getting a similar error when trying to import XML Metadata. I get the error: ActiveX component can't create object: VMDataStage.CDSXMLMDI
I can, however, go to my DataStage client directory ...
Resolved
 Topic: Server vs parallel jobs
gateleys

Replies: 14
Views: 8856

PostForum: General   Posted: Wed Feb 09, 2011 11:07 am   Subject: Server vs parallel jobs
For small volumes of data a server job can be started, run and finished before a parallel job has completed its startup phase.

Ray, what would you consider a "small" volume, versus a "medium"??? o ...
 Topic: How to insert data and capture duplicates
gateleys

Replies: 6
Views: 2328

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 15, 2010 3:47 pm   Subject: How to insert data and capture duplicates
Concatenate all your non key columns from source into a single value and pass this value to CRC32 function. Similarly calculate CRC value from lookup/target table also. If the Key column matches and C ...
 Topic: How to convert String MMDDYYYY to Db2 date MM/DD/YYYY
gateleys

Replies: 8
Views: 4250

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 15, 2010 12:43 pm   Subject: Re: How to convert String MMDDYYYY to Db2 date MM/DD/YYYY
Hi

How can i convert String MMDDYYYY to Db2 date MM/DD/YYYY ?

Eg: '11302009' to be 11/30/2009


Try-

Oconv(Iconv(InLink.YourDate, "DMDY[2,2,4]"), "D/MDY ...
 Topic: Need help creating optimal Static Hashed File
gateleys

Replies: 2
Views: 1851

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 15, 2010 12:32 pm   Subject: Re: Need help creating optimal Static Hashed File
BTW, I have left the Separation to default of 1.
Resolved
 Topic: Day of year
gateleys

Replies: 2
Views: 1386

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 15, 2010 12:29 pm   Subject: Re: Day of year
I'm trying to convert a date to the format YYddd (day of year). Is there any way to do this inside a transformer? I've been trying different things for a couple of days and can't get anything to wor ...
 Topic: Need help creating optimal Static Hashed File
gateleys

Replies: 2
Views: 1851

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 15, 2010 9:40 am   Subject: Need help creating optimal Static Hashed File
DataStage® Release: 7x
Job Type: Server
OS: Windows
I need to create a Static Hashed File that contains the following columns-

Total number of rows = 10,000,000 (10 million)
SomeDateAndTime KEY, TIMESTAMP(19) eg. 2010-05-12 09:30:45
FirstAmount ...
 Topic: Improving Job performance
gateleys

Replies: 16
Views: 5631

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Nov 18, 2010 1:07 pm   Subject: Improving Job performance
You could use an Interprocess buffer between the Transformers so that an otherwise single process be split among the CPUs. Let us know the result if you think it may result in an overall performance g ...
Resolved
 Topic: duplicate and non duplicate data
gateleys

Replies: 4
Views: 1694

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 10, 2010 2:03 pm   Subject: Re: duplicate and non duplicate data
Hi,
A sequential file has 8 records with one column, below are the values in the column separated by space,
1 1 2 2 3 4 5 6
In a parallel job after reading the sequential file 2 more sequential fi ...
 Topic: All different commads to import datastage jobs.
gateleys

Replies: 4
Views: 4534

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 20, 2010 1:03 pm   Subject: Re: All different commads to import datastage jobs.
I use the dscmdexport.exe command wrapped in a batch script that is scheduled from Windows client (that contains DS client) to create the dsx file. It creates a single dsx file for a project and conta ...
 

 Jump to:   



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