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 |
explain about citrix scheduling tool in datastage
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What is datastage?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
client know skid info?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
How we can convert rows to columns in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls