| interface [message #194113] |
Wed, 20 September 2006 17:05  |
shubha456
Messages: 5
Registered: August 2006
Location: Florida
|
Junior Member |
|
|
1)How the data stored in staging tables are validated.
2)Where will the error records of staging tables will get stored.
3)Do we need to process the whole records and validate again and put into staging table?
4)Where will the error records of Interface tables will get stored.
|
|
|
|
| Re: interface [message #194129 is a reply to message #194113] |
Wed, 20 September 2006 22:11  |
saurabhsaraswat
Messages: 11
Registered: August 2006
Location: NOIDA
|
Junior Member |
|
|
Hi,
1)How the data stored in staging tables are validated.
The data stored in staging tables are validated yhrough various procedures and user defined functions.We transfer only validated data into the interface tables.
2)Where will the error records of staging tables will get stored.
There is no table to record the staging tables error records.
they will generally remain in the staging table if the validation fails.
3)Do we need to process the whole records and validate again and put into staging table?
No, you have to process only those records which fails in validation.
4)Where will the error records of Interface tables will get stored.
The error records of interface table will remain in interface table only with some error flag set.
You can check the error reason by checking the error table for that interface or in some cases a report is genrated after running the interface so you can check that report also (eg. GL Interface).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
