since ‎09-08-2017
‎10-12-2019
mithiltaneja
Level 1
Re: Composite Key
Avatar

mithiltaneja

mithiltaneja
- Adobe Campaign Standard
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?

Views

469

Likes

0

Replies

0
Re: Composite Key
Avatar

mithiltaneja

mithiltaneja
- Adobe Campaign Standard
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...

Views

456

Likes

0

Replies

0
Composite Key
Avatar

mithiltaneja

mithiltaneja
- Adobe Campaign Standard
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 ...

Views

1.2K

Like

1

Replies

4
Re: How to read the first line of a text document in adobe campaign via javascript coding?
Avatar

mithiltaneja

mithiltaneja
- Adobe Campaign Standard
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?

Views

509

Likes

0

Replies

0
How to read the first line of a text document in adobe campaign via javascript coding?
Avatar

mithiltaneja

mithiltaneja
- Adobe Campaign Standard
Hi, please help me with this.

Views

1.5K

Likes

0

Replies

3
Likes given to
Likes from