Hi Everyone,
This may be simple for some one, i am not able to find correct solution to acheive this requirement, all you are thoughts are acceptted.
I have sourcefile with header and data ,this is in server job
[b]20120422 3 3900
1121 990 1300
1122 991 1300
1123 992 1300 [/b]
My requirement is to validate the header number of records and data number of columns and load data to file and numbers of records to other table.
Let me know if you are able to understand my requirement
Thanks
Sree
Validation in the datastage server job.
Moderators: chulett, rschirm, roy
Re: Validation in the datastage server job.
Requirement is not clear, could you tell what is input data and waht is the expected output supposed to eb?
Re: Validation in the datastage server job.
Input
20120422 3 3900
1121 990 1300
1122 991 1300
1123 992 1300
Output
1)Header record count and number records are matching we need to load data to audit table(number records or else aborte the job.
2) Data direct load to data table.
Thanks
Sree
20120422 3 3900
1121 990 1300
1122 991 1300
1123 992 1300
Output
1)Header record count and number records are matching we need to load data to audit table(number records or else aborte the job.
2) Data direct load to data table.
Thanks
Sree
-
- Participant
- Posts: 15
- Joined: Wed May 02, 2012 3:38 am
follow the Transformer execution flow
if you have any indicator for Hdr and trailor records
then follow the below steps
1) from header record get the value of count using subsring if it fixed widh or u can use field function to get the count no from the header
2)in constraint exclude the hdr and trailr records based on your indicators
3)in derivation take the count of records at there you will exact count of records
4)take the count no from the stage varailble as a column
and then after keep filter stage then check the count if it match then only it process the records other wise it won't process the records
if you want to know whether the records are processed or not you can use the job sequnce uservariable activity...
'
-------------
Venky
then follow the below steps
1) from header record get the value of count using subsring if it fixed widh or u can use field function to get the count no from the header
2)in constraint exclude the hdr and trailr records based on your indicators
3)in derivation take the count of records at there you will exact count of records
4)take the count no from the stage varailble as a column
and then after keep filter stage then check the count if it match then only it process the records other wise it won't process the records
if you want to know whether the records are processed or not you can use the job sequnce uservariable activity...
'
-------------
Venky