GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio
Go To First  |  Previous Question  |  Next Question 
 Abinitio  |  Question 194 of 196    Print  
Force_error Function
How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?


  
Total Answers and Comments: 4 Last Update: September 16, 2009     Asked by: mhero 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 23, 2009 10:01:04   #1  
sixto.dsilva Member Since: March 2008   Contribution: 59    

RE: Force_error Function
I think it depends what you want to do with force_error fuction it can used to fail the plan if there are data quality issue for example if you want a plan to fail if they are duplicate records in input file here what you can do is you check for duplicate records in input and put a force error function to fail if there are duplicates in input file.

About the other question regarding the reformat I think if you have a log port and log port is connect to a flow the conponents treats malformed delimited records as rejects events and if you set never abort parameter then reformat will not fail. if you set the other option like abort on first reject the reformat component will fail.

I not sure from what context you want to use the force_error function. But this function is very useful when you want to fail any plan for data integrity issue which is very important in Data warehosue.

I hope it make sense.

 
Is this answer useful? Yes | No
June 28, 2009 15:47:49   #2  
abhi_fresh_as_dew Member Since: September 2008   Contribution: 12    

RE: Force_error Function
force_error as the name suggests it works on as to force an error in case of not meeting of any conditions mentioned.

The function can be used as per the requirment.Viz.

1. If you want to stop execution of graph in case of not meeting a specific condition say you have to compare the input and out put records reconcilation and the graph should fail if the input record count is not same as output record count
"THEN set the reject-threshold to Abort on first reject" so that the graph stops.

N.B - force_error directs all the records meeting the condition to reject port with the error message to error port.

2.In certain special circumstances you can also use to treat the reject port as an additional data flow path leaving the component. When using force_error to direct valid records to the reject port for separate processing you must remember that invalid records will also be sent there. When using force_error for this purpose "set the reject-threshold to Never Abort" so that the graph doesnot fails and meets the purpose.

Njoi!!
Abhi - fresh as dew!

 
Is this answer useful? Yes | No
August 09, 2009 07:20:40   #3  
sixto.dsilva Member Since: March 2008   Contribution: 59    

RE: Force_error Function
Here you can set the two conditions for the reformat component
1. If you want to fail set the reject thresold to fail on first reject
2. If don't want to fail you set never to abort.

Force_error is used to abort any graph if the conditions are not met and you write the error errors records in file and then abort the graphs this can done in different ways.

 
Is this answer useful? Yes | No
September 16, 2009 06:06:19   #4  
Mihira Barik Member Since: September 2009   Contribution: 5    

RE: Force_error Function

force_error() fuction will not stop the graph it will write the error message to the error port for that record and will process the next record.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape