DSXchange

Yes it is purge

I'm looking for the logic to implement in datastage.

Thanks
Sunitha

Hi All,

I need to take a backup of records of 1 year at the end of every seventh year.
How could we implement this scenario .


Thanks
Sunitha

Hi,

The tables do not have BLOB data type and i have tested the generic job by enabling run column propagtion to load single table .

But multiple tables need to be loaded using the same generic job.

Please let me know your ideas on this.

Thanks
Sunitha

HI,

I created a generic load job which loads source table into target table.
This job should loads mutiple source tables from one server into multiple tables in another server .

Please let me know how can this be achieved .

Thanks in advance.

Thanks
Sunitha

Thanks William,


I had used a modify stage stage to do this it worked .

Thanks
Sunitha

Hi All, I'm trying to use a CCD stage to capture the delta data loaded. The design is 2 teradata connector stages connected to CCD stage and the target stage is teradata connector stage. I'm unable to eliminate the change_code column from the preceding stage. the records are loaded till the last lin...

Thanks Paul,

What are the impacts on Datastage jobs if we move to Grid.

Thanks
Sunitha

Hi All,

We are planning to migrate our DS code to Grid.
Please let me know the changes to be done in DS Jobs if we migrate to Grid.

Thanks
Sunitha

Hi Ray,

We have got the scramble algorithm.

Thanks
Sunitha

Hi Ray,

We are using DS 7x parallel jobs for our developemnet.

Could you advice me on this.

Thanks
Sunitha

Hi,
The numeric input has to masked .
No bussiness logics applied.

Thanks
Sunitha

Hi, I have a requirement in the below manner. I need to mask some values in 18 byte data sent to me . The value is read in 1byte to 9 byte . Few values need to be masked the data extracted is numeric but after masking they result in numeric and non numeric values. req 123456789 output 1M3AXSD89 Coul...

Hi, When loading data from dataset TO teradata stage we could see the following error no more spool space in project. table exists:failed on query :lock row access select count (*) from database. Table does not exist ,cannot use truncate mode. cannot prepare target table. appreciate your help on this.

Hi , we are loading some records from a dataset to a teradata stage. At this point of time temp tables are created in teradata. The job design is dataset ->transformer->teradatastage(write mode is truncate). but the issue is job aborting and table dropped when data is loaded into the tablename1. The...