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.
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
By using the following command you can remove blank lines from unix file:
$ sed 's/ *//g' sample
Using Control-M Tool.
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
6. If a column contains data like
how to send the unique data to one source and remaining data to another source?
by using create key change column is true is disp;ays
if it is false it displays non duplicate records
first keep all the records in sort order
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.
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.