DSXchange

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

IBM suggested to add this environement variable - APT_NO_PART_INSERTION and set to true.

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...

Hi all, thanks for your help.
We loaded the lookup data into datasets and used the join to perform the lookup operation.

Thanks!

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...

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!

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...

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 *...

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...

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...

Is there an option to implement Sequence generator/surrogate key generator functionality in Datastage TX 8.1; without the use of database create sequence?

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...

have a look at this post for more details. http://www.dsxchange.com/viewtopic.php?t=124275 I found out the reason for that. That space is to display the sign of the number. If its a positive number, we have a space preceeding the number. Ex: 8.54 would be " 000008.54". If its a negative n...

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 ...

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...