Event log table requirment through datastage
Posted: Sun Jan 17, 2016 9:03 am
Hi all,
We need to create a event table which captures information of each event for each job which happens during running of job. The table(EVENT_LOG) will have below columns.
1)Event_code(text)
2)Event_type_txt(1) example:-Error,Warning, information
3)Event_message example :-message from code
4)Object_code example:- hard coded to file name or table name(source)
5)PK_field_name example: PK field name of source file or table
6)PK_field_value example : value of PK which caused the event
7)SRC_field_name example: secondary column which caused the event
8)SRC_Field_value example: column value which cause event may be a look up failure
9)Data_Record example:Actual record which caused the event.It should be same as what is in source.
is there any ways this can be done in Datastage. any suggestion where in we can create any other table to which can materialize this table.
We need to create a event table which captures information of each event for each job which happens during running of job. The table(EVENT_LOG) will have below columns.
1)Event_code(text)
2)Event_type_txt(1) example:-Error,Warning, information
3)Event_message example :-message from code
4)Object_code example:- hard coded to file name or table name(source)
5)PK_field_name example: PK field name of source file or table
6)PK_field_value example : value of PK which caused the event
7)SRC_field_name example: secondary column which caused the event
8)SRC_Field_value example: column value which cause event may be a look up failure
9)Data_Record example:Actual record which caused the event.It should be same as what is in source.
is there any ways this can be done in Datastage. any suggestion where in we can create any other table to which can materialize this table.