| |
GeekInterview.com > Interview Questions > Data Warehousing > Abinitio
| Print | |
Question: Force_error Function
Answer: 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 ? |
| June 06, 2009 10:01:04 |
#1 |
| sixto.dsilva |
Member Since: March 2008 Total Comments: 56 |
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. |
| |
Back To Question | |
