DSXchange

you can be use the pivot stage for that target

use the functions ICONV() and OCONV() instead of using timestamp to date in parallel job

could be Use Oconv() and ICONV() fuctions after compare that

can be use Aggregator stage for that or compare the two records using join or merge stage after that use aggregater stage

That information is confidential.........
sometimes pass the value in that particular variable.............
so no need to get that information........

In Windows mode we can set Environment variable using Datastage Administrator
In Unix mode we can set Environment variable using $DSAdmin command

Analyze the values of input and output and can be use SCD stage or lookup stage

check RCP at job level and admin level

1.Minimize the usage of Transformer(instead of use copy,modify,filter,row generator) 2.Reduce the number of lookups in job design use not more than 20 stages in a job 3.There is no limit for no of stages like 20 or 30 but we can break the job into small jobs then we use dataset stages to store data ...

can be use Trim(),Ltrim() and Rtrim() fuctions within the transformer for example first count the total length of character is 18 source -> transformer -> target SunilBassi03101234 Ltrim(18,13) Sunil Here total length is 18 but we need first 5 character only use that function and if else statement a...

could be use the limitations given below
1.set datatype as EDCDIC
2.target table should be empty
3.insert only allowed
4.loads only one table in one job task

in ds7.5 transformer can be use seconds from time(time) functions and date and time funtions are available

1.in ds8.5 separately SCD Stage is there otherwise can be use Slowly changing dimension(SCD) Concept types SCD1-Insert new records and replace the orginal records SCD2-insert new records and update the existing records and we can maintain the old records also SCD3-insert new records and no trace of ...

Sequence numbers can be generated in Datastage server job transformer using certain fuctions like select ... ->funtions tab->dstransform->sdk->keymgt->select given below functions - KeyMgtGetNextVal(seq name) - KeyMgtGetNextValConn(seq name) Sequence numbers can be generated in Datastage parallel jo...

1. in 8.5 transformer options llike (do- while) available in looping structure but not available in 7.5 2.in 7.5 can set the single parameter using environment variable but parameter set options are available in ds8.5 and patameter set means collection of variables 3.in 7.5 quality stage has seperat...