DSXchange

Hello Forum, I have a need to convert a string from EBCDIC to ASCII for the purposes of doing some logic in stage variables. I would like to do this in a Parallel transformer if possible. I was adding the EBCDIC attribute to the schema file, and this was allowing my stage variable logic to evaluate ...

Hello Forum, My client is interested in integrating File-Aid into their Ascential platform for test data masking purposes. We wish to reduce the amount of overhead involved with reconfiguring File-Aid every time the Table Definition changes inside DataStage. Are there adapters in MetaStage or produc...

Thanks track_star,

Not only did that eliminate the warnings, but startup time improved by a factor of 10 and runtime by a factor of 3!

More Info from poster: 1. There are no failures, only warnings. 2. My config file has 2 nodes. 3. Only one of the warnings is still appearing. Please ignore the first one I reported. 4. Additionally, there is one information message after the warnings with the following report: DateControl,0: Orches...

It turned out, Teradata Utility loader package was not installed. It is now working.

Thanks for you help,

Greg

More Info: 1. TDML stage is not working even in server jobs imported from another environment. I receive the same error on server jobs. 2. Setting Combinability to 'Don't Combine' let me see that the parsing of the sequential file was working correctly and that it was the TDML stage not working. The...

Hello Forum, I am trying to get the Teradata multiload stage working in a parallel job in a new environment. I have already successfully input and output using the Teradata Enterprise stage in this environment. I am receiving the following error using the Mutliload: APT_CombinedOperatorController,0:...

Thank you for your response. Then, yes, it's true within the Lookup stage. But you could, of course, precede the Lookup stage with a Column Generator stage that uses a cycle from N to N for the column in question (one way to generate a constant). Currently, I precede with transformer that appends th...

Hello Forum, I am getting many strange warnings (close to 100). They come in the form: ExtractConfiguration,3: Query returned no results. No read will be performed. DateControl,9: Insufficient blocks for partition 9. Reading suppressed. They occur when performing a lookup against Teradata Enterprise...

ray.wurlod wrote:Presume you're using a Lookup stage here. Are you on 7.5 or an earlier version?

Version 7.5x2.
Yes to Lookup Stage.

Hello Forum,

It seems like the ability to provide a constant value for one of the key columns in a lookup is not possible in PX, as it was in server jobs. It looks as though you are forced to only use input columns in the key expressions.

Is this true?


Thanks,

Greg

Hello MHilts, Other Differences: 1. Remove Duplicates makes it much more visual that you're deduping, making it more consistent with the GUI based development. 2. The Sort stage only allows you to at best choose retain the first record from each group, but remove duplicates allows you to choose eith...

Hello, According to DS documentation the Standard Deviation functionality on the Aggegator should work for all numeric types. I switched my input and output column data type from a integer (working) to decimal(15,2). It is now not working. The warning message received is: WorkDW00QL_TrendTest..CntrC...

I understand the features of RCP in only naming columns necessary for transformation. I also understand that I can specific column information at runtime using a schema file. Is it possible to name a table definition from repository at runtime rather than a schema file? Anybody know if such a featur...

Here is example of calling external program. You should adapt this to call env instead.

Expression="env | grep '^ABC='"
call DSExecute("UNIX", Expression, Output, SystemReturnCode)

Output would then be assigned something like "ABC=somevalue"