How to enter a log in auditing table whenever a job get
finished?
Answers were Sorted based on User's Feedback
Answer / chandu
some companies using shell script to load logs into audit table or some companies load logs into audit table using datastage jobs.these jobs are we developed.
| Is This Answer Correct ? | 6 Yes | 2 No |
Now, for auditing Datastage jobs, you can use Operation Console database ODB to fetch the same details easy way
Thanks
www.datagenx.net
| Is This Answer Correct ? | 2 Yes | 0 No |
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
How many types of sorting methods are available in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
How did you reconcile source with target?
What is the purpose of interprocessor stage in server jobs?
wt is the difference between swith and filter stage
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
1.what is materialized data? 2.how to view the materialized data?
How can we improve performance of data stage jobs?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C