Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship

Answers were Sorted based on User's Feedback



How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / madhuri motwani

Hello,
I assume that 1: M in this case is 1 account linked to many
opptys. and the reason you would be need a PRIMARY pty
becuase opportunity would be an MVG on Account applets

You can use any column to create a PFK column. Use any
unused field in S_ORG_EXT or S_ORG_EXT_X to create a
field "Primary Opportunity Id"

On the table level, on S_ORG_EXT, set the Foreign Key Table
as S_OPTY for the chosen field

On the BC,
1. Create a new field "primary Oppty id"
2. create a link between the two BCs and set the Primary Id
field as above

Is This Answer Correct ?    2 Yes 1 No

How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / shankar

it is not possible to create in account for opty. the reason
is you were not aware of the entities (say what is contact,
opty,account,activity) Opty is a lead through which we
generate income. account is an organization it can be
internal or external. You are trying reversal that is not
possible

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Siebel Interview Questions

when you have pre default value and post default value for a field, which one will be stored in the database?

0 Answers  


If we can invoke a custom method using applet property "CanInvoke" what is the need to use webapplet_precaninvoke event method what is the difference

3 Answers   IBM,


Explain while importing product or account data why we are populating bu_id?

0 Answers  


How do you recognize that a particular table (base table) can be extended?

0 Answers  


What are "Renormalised columns"?

1 Answers  


Explain how to assign responsibilities to employees in siebel?

0 Answers  


What are the steps for creating a mvg?

0 Answers  


Why do you need to create employees at the database in Siebel?

2 Answers  


Which etl tool you used for data loading?

0 Answers  


when i click on first time ststic picklist valus should be 4 values and if i click next time i want to see 6 picklist with diff values for that same field.How will u configure

0 Answers   IBM,


Explain what is symbolic url in siebel?

0 Answers  


When do we go for bc level user properties?

0 Answers  


Categories