DSXchange

I have a table in the database I'm working with that has a huge number of not null columns. All of these columns have a default value coded into the ddl. The job I'm working with needs to be replicated quickly for 60 other tables, so I really don't want to manually type in all of the default values....

Ah, excellent. I was looking in the wrong spot. Within the stage I set the SQL action to Insert, then lower down in the list I changed the append option to create instead. These changes are being made within my output Netezza stage. I've set it up so I have the input connection to the MySQL database...

Is there any way to do this with a Netezza Database? I don't see create in the Netezza options.

Sura's solution did not apply to my problem. I'm currently working with IBM to resolve the issue, but it looks like there were some configuration errors in the destination datasource. I'll share any helpful information if I am able to.

I have a series of tables in a source database, and I would like to create a copy of all of those tables in my staging database. I have job parameters that I am able to use, but I do not have direct access to the source database. With this information I was able to import table definitions. Each of ...

This is the first CDC job my team has dealt with.

The latest events are days old, they have no relation to the current work. Some of the most recent events I could find are months old.

I have checked every event log I can find for CDC both on my local install and the server. Neither has recent events.

I am trying to use the IBM CDC tool to send flat files into datastage. I have both my datastores set up correctly, yet after making a subscription the program crashes when I try to map tables. I receive the following error: Updating the tables available for replication... Loading users... Loading so...

You don't need the uservariable stages, it would be possible to build the full string of updated tables in one step. Eventually this job will run 25+ ETL jobs though, so it's much easier to maintain if I break it into small pieces.

The problem can be solved by having a single userVariable activity that processes USERPROFILE_Status.$JobStatus after the job has completed.

This is what I'm trying so far:

Based on this site: http://www.myonlinetrainings.com/study-material/Datastage/DATASTAGE%20jobsequence%20process.htm It looks like I can use one UserVariable stage to modify another. I tried setting a variable before my main ETL job then having the job branch based on "Failure" or "Oth...

I'm not going to disrupt actual loads, this is all ETL work. Essentially what I'm trying to do is keep a table of last sync dates for the concerned tables. I only want to sync new information in the tables, which is why I am keeping a record. If a table sync correctly and the job doesn't fail, then ...

I would like to have a variable passed into a job that says if another job either succeeded or failed. My original thought was to have a job activity branch based on failure or success and have a userVariable set on either path. That doesn't work though, because I can't have two userVariable activit...