Hi Raghav thanks for the information, Option 2 does look the best
solution but accountId is coming as string.so can we use
marketId(integer) of lookup table along with accountId (string).Note:
market code would be 2 char max. (IN, US etc.) but accountId can be of
10 chars, so anyhow we have to use a string for composite so which would
be better? or is there any other solution to have this solution
implemented with integer composite key? Maybe we can use
autopk(recipientId) and marketId somehow?
Hi Raghav thanks for your reply,1. Let the system have an autopk column
and define unique index on the combination of accountid and market
code.- This solution looks easy and good for implementation but won't a
combination of accountId(string) and marketCode(string) to be used as a
composite key would pose issues? or it would work as fine as integer
keys? we need to link other tables to this table also through PK-FK
relation for which should we use combination of both indexes to identify
every o...
Hi we have a unique key "account id" which is string by data type, we
were trying to make it PK but found that it is getting repeated through
several markets.So we would be making it a composite primary key of
account id (string) and market code(string), but as per the best
practices composite key is not recommended & also strings in keys should
not be used.Could you please help us to get a work around this to define
a key using account id and market? or how we can go with string
composite keys ...
Hi Vipul,Thanks for the code. var file = new File( fName );Can this code
be modified to use a file downloaded from the file collector activity
which is in temp db.Could you please help me with that?
