Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2009-03-05 : 20:25:18
|
| The process for the PRACTITIONER Table: Each record within the flat file contains practitioner data for two “Other” non-billing providers. This information is contained in columns 49-52 (in the layout). Since it is possible for one provider ID to play different rolls on different claims, we can not aggregate this table like the provider table. A single PRACTITIONERDIMID will need to be created for each record coming into the CLAIMFACT table. Then, for the PRACTITIONER TABLE where columns 49-52 have data, a unique record created for columns 49 and 50, and a unique record for columns 51 and 52. Both of these unique records would have the same PRACTITIONER ID as the associated record in the CLAIM FACT table. Can any one explain how to achieve the asking goal. I know it is simple but i have confused with (49 and 50) and (51 and 52) unique records. can any one give me the logic.-Thanks N Regards,Chinna. |
|
|
|
|
|
The process for the Fact Table