DSXchange

The columns ColA, ColB and ColC are only created depending on how many records there are in another dimension table. So if a customer were to stage more records into the dimension table, I would want a datastage job that can handle the addition of more columns.

Is there a way to add/drop columns in a parallel datastage job during runtime?

For example: If I have a db2 table called Table1 with ColA and ColB, I want to be able to run a datastage job that can add ColC or remove ColA or ColB.

Is this possible?

I realized I can't leave client instance name blank for remote db2 connections.

I am having trouble trying to connect to a db2 database in the SCD stage using surrogate key. My datastage server and db2 server reside on two different machines. I have tried db2 catalog and was able to connect to the remote db2 database just fine from the datastage server. I'm able to connect succ...

I am trying to grab a .csv file and insert the data into a db2 database.

What are the necessary steps in order to get datastage to be able to connect to the hdfs and be able to retrieve the file. Can we configure this without BigInsights?

I'm trying to open the WSDL for my information service that I have deployed. I logged into the web console and all I see are Home, Administration and Reporting tabs but there is no option for Information Services Catalog tab. How do I get this option to show up?