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-04 : 18:47:21
|
| 1) I have a table called Provider and it is holding ProviderID and ProviderDimId, and 2)i have other table called ClaimFact and it is having the column ProviderDimId and other columns, Source for both the tables are from same flat file. Now i want to load <b>ClaimFact</b> table with ProviderDimId (That is populated for ProviderID of Provider table) and ClaimFact table is not having any ProviderId column.What is the best approach to fulfil this?-Thanks N Regards,Chinna. |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2009-03-05 : 22:53:42
|
| You'll need a Multicast and probably 2 conditional splits. Can you provide some sample data or metadata?---------------------Tim Mitchellwww.BucketOfBits.com |
 |
|
|
|
|
|
Loading flat file