Hi guys,
Please design a job for dis requirement with
derivation(solution).
my source table like dis.
emp_no qualification
1 a
1 c
2 a
3 c
3 b
To loaded to target like dis
emp_no qualification
1 b
2 b
2 c
3 a
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
Thanks.
No Answer is Posted For this Question
Be the First to Post Answer
How to implement complex jobs in data stage?
What is a merge in datastage?
Why we need datasets ratherthan sequential files?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
How to initialize environment variables?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
What is the difference between odbc and drs stage?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
Explain ibm infosphere information server and highlight its main features?
source file is having 5 records while moving into target it want to be 10 records
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.