I have a input data like,
And i want my output data like
class_id Marks Rank
101 50 2
101 60 1
101 40 3
102 90 1
102 35 2
how to do this in datastage?
please design a job with derivation(solution).
write exact conditions.
Here every employer have three qualifications i.e a,b and c.
what ever source table dont have some qualification, that
will be move to target table.
Hope u get the point.
Please design a job for dis requirement with
my source table like dis.
To loaded to target like dis
my requirement is
every employer have three qualifications i.e a,b and c.
what qualification missed in source table that will be move
to target systems.
Hope u got it the requirement. Right
In sequencer job,
we have 3 sources, in that 1st source have some records,
Here requirement is 1st source records are 100 then only run
the job otherwise total job will abort...
How to calculate this. please design the job.
How to create a file using vi editor?
2)how to delete a file in vi editor?
3)How to connect the server datastage to unix? what r the
command lines we r using?
4)30 jobs r runnig in unix i want to find out my job. how to
do this? give me command?