ETL logic using server jobs
Posted: Wed Jul 18, 2012 1:22 pm
Hi
We have text file as source,it contains only one column.The first row is related to job status of second row which is jobname, and third row is related to job status of fourth row which is Jobname and so on.....
The output should contain 2 columns i.e job status and that particular jobname.(it is guaranteed that jobstatus and job name are in respective sequential order only)
eg :
Input :
COLUMN
-------
RUN OK
test_seq
WARNING
test_seq1
FAILED
testseq2
Output :
Jobstatus Jobname
-----------------------
RUN OK test_seq
WARNING test_seq1
FAILED test_seq3
We are using datastage server jobs.(7.5v) on Windows server.
Solutions we had tried :
We had splitted the single source link into two links using Transformer constraints as Mod(@inrownum,2) = 0 into one link(it contains data as
test_seq
test_seq1
test_seq2
and the Mod(@inrownum,2) <> 0 into second link.
RUN OK
WARNING
FAILED
We are not sure how to combine these two links to get my desired output.
i.e
Output :
JObstatus Jobname
-----------------------
RUN OK test_seq
WARNING test_seq1
FAILED test_seq3
Can anyone help me on this.
Thanks
Kiran
We have text file as source,it contains only one column.The first row is related to job status of second row which is jobname, and third row is related to job status of fourth row which is Jobname and so on.....
The output should contain 2 columns i.e job status and that particular jobname.(it is guaranteed that jobstatus and job name are in respective sequential order only)
eg :
Input :
COLUMN
-------
RUN OK
test_seq
WARNING
test_seq1
FAILED
testseq2
Output :
Jobstatus Jobname
-----------------------
RUN OK test_seq
WARNING test_seq1
FAILED test_seq3
We are using datastage server jobs.(7.5v) on Windows server.
Solutions we had tried :
We had splitted the single source link into two links using Transformer constraints as Mod(@inrownum,2) = 0 into one link(it contains data as
test_seq
test_seq1
test_seq2
and the Mod(@inrownum,2) <> 0 into second link.
RUN OK
WARNING
FAILED
We are not sure how to combine these two links to get my desired output.
i.e
Output :
JObstatus Jobname
-----------------------
RUN OK test_seq
WARNING test_seq1
FAILED test_seq3
Can anyone help me on this.
Thanks
Kiran