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
please design job for this,
MY INPUT IS
MY OUTPUT IS
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.
Explaine the implimentation of scd's in ds indetail, please
send me step by step procedure to perform scd's 1,2,3.
Please replay for this,
Thanks in advance
1)s.key generate 1 to 700 records today. tomorrow another
400 will updated how to update the records using s.key
2)source is like :--
DB --> T/F stage1 --> seq1file
T/f 1 is linking with T/F2 ---> seq 2 how to load the data?
in source i given some conditions those r going in seq1.
The another data will going to seq2 how to do this ?
how to read 100 records at a time in source
a) hw is it fr metadata Same and
b) if metadata is nt same?
i have a job with 3 possibiliies
finish with ststus ok
how do you handle these 3 in job sequence?
explain the situation where you have appiled scd in your project? chandu
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how?
2.how to schedual the job in datastage7.5 2?
what is the deff bet grip and fgrep command?
how do you cleanse the data in your project