Data Stage

When we want to kill the process in unix we need clean up resources.

Actually to kill any process we need process id. Then this option is available in administrator then we have to check the option called clean up resouces

In order to reduce the warnings you need to get clear idea

about particular warning, if you get any idea on code or

design side you fix it, other wise goto director-->select warning and right click and add rule to message, then click

ok. from next run onward you shouldn't find any warnings.

by using create key change column is true is disp;ays

duplicates records

if it is false it displays non duplicate records

first keep all the records in sort order

seq file ------> Transformer -------> target

1.extract the source data into seq file.

2.In transformer source column to target , and apply the field function

Field(column name, ',' , 1)

next same drag the source column to target , and apply the field function

Field(column name,',',2)

.

.

.

Field(column name,',',5)

By using the following command you can remove blank lines from unix file:

$ sed 's/ *//g' sample

Using Control-M Tool.

in sequential file there is one option is there i.e

filter.in this filter we use unix commands like what ever we

want.in this question we use uniq command in filter.

String("o",1):Column name

Here 1 is how many zeros we want

audit table is nothing but when the job is developed,how many no of stages are used,each stage having how many no of input records are there also how many no of out put records are there,job start date,job end date etc these information having audit table

some companies using shell script to load logs into audit table or some companies load logs into audit table using datastage jobs.these jobs are we developed.

It is not possible to generate alphanumeric surrogate key

in datastage.