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

What will happen after the content groups gets created?

0 Answers  


What are the different elements in Siebel?

1 Answers   Cap Gemini,


What is constrainted picklist? Where you will drop the constraints?

3 Answers   Siebel,


How do you configure shuttle applet

1 Answers   Polaris,


Explain how is siebel 7.x data model is different from siebel 6.0 data model?

0 Answers  


What is the primary difference between Siebel 7.5.2 and 7.7 Versions ?

1 Answers  


What are the different screens available in Siebel?

0 Answers   Cap Gemini,


Explain what is resonate?

0 Answers  


best practices in scripting and workflows?

1 Answers   TCS,


What is inbound in picklist?

0 Answers  


Explain how to create extension table to an interface table in siebel?

0 Answers  


Explain how to improve your performance in views?

0 Answers  


Categories