Posted: 8/2/2010
My Source Database has 4 tables
Insured Broker Broker Details Broker Address
Name name id Address1
Address1 Phone Number Email Address2
Address2 ID Fax City
City
State
Zip Code
ID
My Destination Database has Tables
Party PartyRoleType PartyAddress Address
PartyID PartyID PartyID AddressID
PartyCode PartyCode PartyCode AddressCodeID
PartyshortName RoleTypeID AddressID AddressLine1
PartyFullName RoleTypeCode AddressCodeID AddressLine2
(INSURED/BROKER ) Email
SourceID SourceID SourceID ZipCode
SourceID
I need to Map Source with the Destination.As per my analysation with data I feel that
Based on RoletypeCode if its INS then I should get insured details in Destination.but I don’t have any direct mapping column bet ween source and destination.
If its BRK then I should get Broker details in destination
In source I have ID has Unique Column
In Destination I have SourceID has Unique Column.Source ID is coming from SourceSystem Table we have all the entries for different sources.for my sourcedata base SourceSystemID is 3&for destination its 6 .
I m trying to analyse this from 3days.pls suggest me best ways to do this.
Posted: 9/8/2010
I'm not completely sure what you are trying to achieve here. It sounds like you may want to be doing a conditional split to load different tables based on what record is coming in by the sound of this:
veni said: Based on RoletypeCode if its INS then I should get insured details in Destination.If its BRK then I should get Broker details in destination
Based on RoletypeCode if its INS then I should get insured details in Destination.
...but I can't be sure. Could you please provide some better details as to what you want to do.