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...

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 wou...

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 i...

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?

Hi, please help me with this.