DSXchange

Hi

Try this..

Send the common value to the file.

Write a routine to read the file and return the common value.

In Sequencers add routine activity to invoke the routine.

In job activity access the return value of the routine

Regards
Balaji

Hi I do not know whether any function is available or not for rounding up values. But In Edit column meta data dialog box when datatype is decimal there is a property called "Rounding" which you can use to round the source field to destination decimal values. Check this out if you find thi...

Hi

Thanks for your reply.

That is correct. I want to know whether we can override the default date format say i have three date columns and i want each date column to have different date format.Is this possible in modify stage?

Thanks
Balaji

Hi I have input data Datestring as string to the modify stage in the format "05112005"(ddmmyyyy) Using modify stage i need to convert the Datestring to date 11-05-2005(mm-dd-yyyy). In the specification property of modify stage i type: Newdate:date = date_from_string[%dd%mm%yyyy](Datestring...

Thanks for your responses. It was very useful. I have checked surrogate generator stage. It can accept values hardcoded or job parameter. Values can be given to job parameter in design time or before the job run when it asks for value to be given. In both the cases i hardcode the value in the job pa...

I have two links namely customers,maxcustomer. customer link outputs all customer present in sequential file named customer.txt which has 1000 rows. maxcustomer link outputs maximum customerid present in sequential file customer.txt. I need to generate surrogate key for the customer dimension such t...

Thanks for your response.
I could not get clear idea by reading documentation.
Please explain about filesets and datasets.

Thanks

Hi I am just a beginner in datastage and i have a basic question. What is fileset? What is dataset? What is the difference between those two? I read that "fileset is used to overcome 2GB limit". I could not get the meaning of it. Can someone elaborate on it. Thanks in advance.