DSXchange

Hi,

Did you use the GUI to insert the job parameter.

The job parameters are not marked with # in transformer.

Dont use the hand coding. Rather use the GUI.

HTH
--Rich

Hi,

It should be #$DS_LAND#/surr_file.txt.

How did you insert the parameter?

Dont do the hand coding. Use the GUI to insert the parameter.

HTH
--Rich

Hi,

Check if the job is being monitored in the Director. Just change the view in Director from log view to status view.

Let us know what happens.

There are also other options in Director like Clean up resources and Clear status file which can be used to release the locks if any.

HTH
--Rich

Hi,

Import the APT_STRING_PAD_CHAR environment variable as job parameter and try to use 0x20 as the parameter value and let us know what happens.

HTH
--Rich

Hi, You have to check for both the conditions whether the incoming value is a NULL or if it is an empty string and then set null. You get these kind of issues when there is something logically wrong in the stage variables. The best solution would be as Sainath suggested to put the derivation in the ...

Hi, It is APT_PM_CONDUCTOR_HOSTNAME and not APT_CONDICTOR_NODE. Did you get answers for other questions? The default node pool is the one which is marked as "" in the node pool list. By default the parallel engine executes a parallel stage on all nodes defined in the default node pool. The...

Hi, Check the Teradata multiload report file which you would have specified in the Teradata Multiload stage. There will be 5 phases of operation. Based on the phase of operation multiload might lock your table. You also would have mentioned the log table, Work table and Error table. Yes, you would h...

Hi,

Iam trying to post new topics on the Cognos BI forum to get it started but it does not allow me to the post the topics unless I give the options for Datastage Version, Job Type and OS details.

Are these 3 options required for Cognos BI forum?

TIA
--Rich

Hi Srini,

There are 2 ways of deleting the dataset. The dataset management utility and the other is the orchadmin. Since orchadmin is a command line utility all you need is a shell script. It does not require a PX routine.

HTH
--Rich

Hi,

What is the compilation error that you are getting?

What makes you think the compilation error is because of SCD stage?

Did you mention that the surrogate key generator is a database sequence and not a file?

--Rich

Hi,

Use the CommandExecution or Routine Activity in the sequencer to delete the dataset.

HTH
--Rich

Hi,

You can use the orchadmin command to truncate the dataset. You can use the orchadmin command in command activity or routine activity.

HTH
--Rich

Hi,

A Transformer stage with 4 stage variables for C1, C2, C3, C4 should do it.

HTH
--Rich

Hi Pravin,

In the filter stage don't use the link name. Just use the column name like data='100'.

HTH
--Rich

Hi,

You are still not clear on your requirement. But how does it help if the column names are aligned agianst the data.

--Rich