DSXchange

I really doubt if you can use FTP stage for XML files. Because FTP stage can not interpret XML files. May be you can use Unix FTP for file transfer, and by using XML stage you can interpret the XML file. Why do you have to interpret the XML file for FTP? Just read the XML file through a Sequential ...

Remember that if it is a Parallel job, then @OUTROWNUM and @INROWNUM would get executed on each of the nodes for the job run. Meaning that - if you give a constraint @INROWNUM<=1000 and the job is run on a 4 node config, then the transformer would send out 1000 rows from each of the nodes - giving y...

i am getting date fields in the file as 12252001 i want the field to load into oracle table i am using timestamp() and iconv/oconv to insert into oracle table. but i am getting null values when it is inserted. how to resolve this issue You will need to handle the nulls before they are converted int...

How are you getting to the input and output count in your job? If you need the number of records written into the file, you would need a separate job to load this information into the table. If it is the number of records going into the file (assuming that you dont want the reject count if any) - th...

Why not just put the condition in the Trigger and link it appropriately to Notification Activity and the other DS activity that need to be triggered? Again it would depend on the condition that you would want to specify - what theoptimal solution is. What is the condition that you need to trigger th...

In the Server version, you dont have a Teradata Enterprise stage. The Enterprise stage and the API stage work differently. First check if you you have enough Perm space and Spool. (the developer's guide say atleast 100 MB of perm and 10 MB of spool) in the database that you are trying to acess. If t...

If you want to specify DSLink 4 as the reject then give the constraint
dslink3.city='Berlin' against DSLink 6 and check the Reject Row check box for DSLink4.

What error are you getting?

y2ariyas wrote:After adding the environment variable, do we have to restart the ds engine? does it help or no? we tried without restarting still same error.

Did you try and follow the post in the link above - regarding the previleges and perm space required for the Terasync table?

Remeber - an empty string is not a null. So, trimming a string which has spaces will not return a null - but an empty string - '' If you need it to return a null, then you would have to explicitly set it to Null based on a condition of the sort - If trim(input.col)="" then SetNull() else t...

mandyli wrote:can i plug-in profile stage in to Datastage.man

If the question was - can you use ProfileStage as a plug-in in DataStage - the answer is NO.

Maybe this will help -
viewtopic.php?p=123206&highlight=#123206

The problem looks more like permission issue. Do an exact search on this forum for terasync and you will get a lot of helpful posts on this issue.

You will have to create this variable as a User Defined Environment Variable.

Aneesh

To use the Teradata Enterprise Stage, you need a Terasync table set up with write access to it. Go through the Parallel Job Developer's guide for details on the Teradata Enterprise Stage and also the Parallel Job Advanced User's Guide (Teradata Environment Variables). Try the Teradata API stage - wh...

Since the data to the Aggregator stage is sorted - the "Sort" method is preferred over the "Hash" - so that DataStage can expect sorted data and doesnt use a hash table for sorting it again.

I have job parameter as list.How I can put dataset with onest colum to my job_parameter? Thenx. Kadet, Do you mean that you have a parameter for the Data Set defined as a "List" in the job properties? And did you mean a Data Set with one column? If you want to pick up the parameter values...