Hi, Is there a way we can integrate a versioning system with datastage?
We are currently using datastage 8.5. Basically we need to integrate a version control system that has checkin/check out capabilities.
Please share your thoughts if you have done similar integration. Thanks
Search found 20 matches
- Wed Aug 03, 2011 8:51 pm
- Forum: General
- Topic: Integrate Versioning system with DS 8.5
- Replies: 2
- Views: 2598
- Tue Jul 19, 2011 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job hangs at the join stage
- Replies: 2
- Views: 3627
issue resolved with a work around
IBM suggested to add this environement variable - APT_NO_PART_INSERTION and set to true.
- Fri Jul 15, 2011 2:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job hangs at the join stage
- Replies: 2
- Views: 3627
Job hangs at the join stage
Hi, We made an upgrade to DS 8.5 by installing the datastage 8.5 fix pack 1. Some jobs have been behaving weird. The jobs hang during execution at the join stage. And the jobs never complete. Work around suggested by ibm was to set the Buffer settings in the Input links of join stage to Buffer (from...
- Wed Oct 13, 2010 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex lookup against huge data
- Replies: 4
- Views: 3458
Thanks!
Hi all, thanks for your help.
We loaded the lookup data into datasets and used the join to perform the lookup operation.
Thanks!
We loaded the lookup data into datasets and used the join to perform the lookup operation.
Thanks!
- Wed Oct 13, 2010 6:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector vs Teradata Multiloader
- Replies: 3
- Views: 4077
Re: Teradata Connector vs Teradata Multiloader
I would like to know the Difference Between Teradata Connector stage vs Teradata Multiloader stage. Also, Can you please suggest which stage would be a best option to use to load huge amount of data - say 5 million rows per run. Thanks in advance! Sorry! I was referring to the Teradata enterprise s...
- Tue Oct 12, 2010 10:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector vs Teradata Multiloader
- Replies: 3
- Views: 4077
Teradata Connector vs Teradata Multiloader
I would like to know the Difference Between Teradata Connector stage vs Teradata Multiloader stage.
Also, Can you please suggest which stage would be a best option to use to load huge amount of data - say 5 million rows per run.
Thanks in advance!
Also, Can you please suggest which stage would be a best option to use to load huge amount of data - say 5 million rows per run.
Thanks in advance!
- Fri Oct 08, 2010 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex lookup against huge data
- Replies: 4
- Views: 3458
Complex lookup against huge data
Hi, We have a scenario where the source would have around 2 million rows, which needs to be looked up against 3 tables based on a composite key (3 key fields) These lookups against the tables are pretty complex, I mean its not a direct lookup against the tables. There's a huge join query that return...
- Fri Aug 28, 2009 1:49 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Wildcard option for filenames in DS-TX
- Replies: 1
- Views: 16539
Wildcard option for filenames in DS-TX
Hi, I was looking for an option to read the file for processing, from an input directory based on a particular naming convention. For Ex: my filenames are expected in the format - ABC_YYYYMMDD.txt. Just like data stage PX, Is there an option to pick the files starting with ABC_*.txt? I tries using *...
- Thu Aug 20, 2009 12:36 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Help Reqd: Unable to load data into the target table
- Replies: 3
- Views: 17718
Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections? ... Yes sir. The database server is available. As you said, may be there are too many connections to the remote machine. I get the same error at times when I r...
- Wed Aug 19, 2009 12:02 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Help Reqd: Unable to load data into the target table
- Replies: 3
- Views: 17718
Help Reqd: Unable to load data into the target table
Hi, I am able to connect to my remote database server using ODBC. I am successfully able to create type trees with this connection definition. When I run my maps to load a flat file into the database, the map loads data into the tables for the first couple of times. From the next run, I get a messag...
- Fri Jul 31, 2009 8:14 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Implementing a Sequence generator in Datastage tx 8.1
- Replies: 1
- Views: 5746
Implementing a Sequence generator in Datastage tx 8.1
Is there an option to implement Sequence generator/surrogate key generator functionality in Datastage TX 8.1; without the use of database create sequence?
- Thu Jul 23, 2009 3:51 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Error Handling with DataStage TX 8.1
- Replies: 1
- Views: 4815
Error Handling with DataStage TX 8.1
Hi, I am trying to have the error records in an error file and also attach the custom error description for the error records. Looks like I cannot define an error message if I place a restart button on the record and use Reject() function to capture the error record in an error file. Ex: If i my sou...
- Wed Dec 24, 2008 6:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: An additional space is prefixed for the decimal fields
- Replies: 3
- Views: 2140
- Wed Dec 24, 2008 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: An additional space is prefixed for the decimal fields
- Replies: 3
- Views: 2140
An additional space is prefixed for the decimal fields
Hi all, I have a strange problem in my datastage code. I am reading data from an Oracle Enterprise stage. I have few fields which are defined as Number(38,10). In the DataStage code(oracle stage) these fields are defined as Decimal(8,2). So, i am casting these fields to Number(8,2) in the SQL query ...
- Thu Nov 20, 2008 4:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String pattern matching in lookup stage!!!
- Replies: 5
- Views: 3992
In version 7 the only possible normal lookup you can do with a Lookup stage is an equality lookup (an exact match is required). You might contemplate using a sparse lookup that includes a LIKE condit ... hi ray, Am working on version 7. Could you pls explain me how i can implement this using sparse...