HOW CAN U DO ERROR HANDLING IN DATA STAGE?
Answers were Sorted based on User's Feedback
Answer / me
HELLO KIRAN,THANKS FOR YOUR RESPONSE,THE ERROR HANDLE
ACTIVITY IN JOB-SEQUENCE IS TO IGNORE ANY ERROR IF OCCUR
AND CONTINUE FROM THE NEXT ACTIVITY,SO BY USING THIS
ACTIVITY WE ARE NOT HANDLING ANY ERROR BUT IGNORING IT.
.SO THINK HOW TO HANDLE(CORRECT)ERRORS
.
Is This Answer Correct ? | 17 Yes | 7 No |
Answer / kishore kumar
Hi.. CEL: 09177549333
This is kishore,
Where?
In datastage ,In Job Sequencer--> Error Handling Availble.
How can we use?
When one more than job activitys srrounded by with Job
Sequencer on that time based on the Error Handling its
shows the error.
How we can slove this error handling?
Go to DataStage Director (or)
Data Stage Desinger-->Tools-->Run Director--> Click on Job
log --> see the error and recomile and reslove the errors
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chenna
Error Handling Availble in Job Sequencer.in
Job sequencer has one activity called as error handle
activity.
in datastage px (one job) we get any error or aborted any
job we can go a datastage director in job give a right
click click on view log.and if u want more details click
on particular error.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / praveen kumar
this is praveen kumar yenduri
yah kiran you are right but make it clear...
once we get the error shift to datastage director..from tool
menu..then from there you can able to c your job then right
click on the job and click on "view log"...so from there you
can resolve your errors and by cing as "fatel error"....
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / vishnu
in job sequencer error handling is available..
Datastage designer-->Tools-->Run director--->then click on
job log..
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kiran
Hi Guy..
Thanks for Replay me in above solution.in datastage
Errorhandle handle error and auto- run and finish jobs
after succesfully then go to ds-director check what and
where error found.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / kranthi
can u explain me in detail about error handling
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kiran
hai..,This is Kiran Kumar .+91 9393363309.
In datastage ,Error Handling Availble in Job Sequencer.in
Job sequencer has one activity called as error handle activity.
Any more call me my no 9393363309
Is This Answer Correct ? | 5 Yes | 21 No |
In merge stage can we update the values?
Which warehouse using in your datawarehouse
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What is PX?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
how to delete one row in target dataset
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
source contains 2 columns comes to target 4 columns how
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please