mithiltaneja
Community profile mithiltaneja Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 09-08-2017 10:02:55 PM
Offline
Top badges earned by mithiltaneja
Customize the badges you want to showcase on your profile
Re: Composite Key
Avatar
Validate 1
Level 1
mithiltaneja
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
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

693

Likes

0

Replies

0
Re: Composite Key
Avatar
Validate 1
Level 1
mithiltaneja
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
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

677

Likes

0

Replies

0
Composite Key
Avatar
Validate 1
Level 1
mithiltaneja
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
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.4K

Like

1

Replies

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

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
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

825

Likes

0

Replies

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

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
mithiltaneja
- Adobe Campaign Standard
Hi, please help me with this.

Views

1.9K

Likes

0

Replies

3
Likes given to
Likes from