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 want job aborted after some records are loaded into output by using only sequential stage and dataset
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What could be a data source system?
how many stages are there in Datastage... Please clarify mee??
Describe link sort?
How to move data set from one server to other?what are the steps to follow to do this?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
types of errors in datastage?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
What are the enhancements made in datastage 7.5 compare with 7.0?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?