GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Siebel  >  Siebel General
Go To First  |  Previous Question  |  Next Question 
 Siebel General  |  Question 135 of 169    Print  
What difference between join specification , join definition, join criteria and link specification?

  
Total Answers and Comments: 1 Last Update: March 09, 2007     Asked by: ansumanpanda 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 09, 2007 09:00:31   #1  
chary Member Since: October 2005   Contribution: 76    

RE: What difference between join specification , join ...

Hi,

Let us write SQL query to understand this:

select s.name,a.name                                 (1) 
from s_evt_act a,                                       (2)
s_srv_req  s                                               (3)
where                                                          (4) 
a.SRA_SR_ID=s.row_id                            (5)


now we look at the ActivityBC:
we can select fields from two or more tables :     see line  (1)
Base Tables:  s_evt_act                                                      (2)
Join definition:
          Join:                   Service request
          Table Name:       s_srv_req                                        (4)

          Join Spec:           a.SRA_SR_ID=s.row_id                (5)

in the same way: 

link will have 1:M relation.
so, link spec (PrimaryKey-ForiegnKey mapping) will have the relation between the two tables (between two BC's pointing fields bought from table level)


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : An organization is a division that is designated as an organizationAn organization exists for the purpose of providing a container in which positions can be associated with data.A division exists for the purposes of mapping a company's physical structure ...

Latest Answer : Hi,For updating join field use Join,Becase in siebel base table filed we can't directly update. All fields are read only it has complex relation ship.RegardsS.Ramesh ...

Latest Answer : Master-detail view displays the child records in different applet for a given parent record,where MVG displays the child record(s) in the same applet. ...

Latest Answer : Implied joins are also called implicit joins. Its a join existing b/w a Base table and its extension table. ...

Latest Answer : EIM: Enterprise Integration Manager is the server component which Transfers the bulk data from one database to another database. We mostly use EIM to IMPORT, DELETE, MERGE, UPDATE the data.EAI: Enterprise Integration Application is also a server component ...

Latest Answer : Join is used for showing fields from multiple tables in a BC. It draws one to one and many to one relationship between the base table and the join table.Link defines the Master - Detail relationship between Parent and child BC's. It architects one ...

What is the difference between "PickList Generic" and "PickList Hierarchical" Business components?
Read Answers (1) | Asked by : KMR

answer 
Latest Answer : Link spec uses parent type default values & gets the value for the child record ...
Read Answers (2) | Asked by : chary

Latest Answer : I want to have some real time business scenarios for my project....can anyone provide me ???? ...
Read Answers (2) | Asked by : Amit Puri

Latest Answer : use of indirect MVL.     consider there are 3 bus comps. in that say there is no relation ship between the 1st and 2nd bus comp and there is relation ship between 2nd and 3 rd bus comp. but some fields are necessary  from the ...
Read Answers (1) | Asked by : Ashok


 Sponsored Links

 
Related Articles

High Level Data Link Control (HDLC)

High Level Data Link Control HDLC The High Level Data Link Control protocol was developed by the International Organization for Standardization ISO It is used for switched and non switched networks and is a bit oriented architecture The High Level Data Link Control has been accepted and used widel
 

Synchronous Data Link Control (SDLC)

Synchronous Data Link Control SDLC The SDLC or the Synchronous Data Link Control was first developed by IBM It is basically a linked layer protocol which can be used with systems network architecture or the SNA environment In this system all the functions in a network can be defined and slotted into
 

How ERP Improves General Ledger Capacity

How ERP Improves General Ledger Capacity Flexibility quickness and efficiency are the pillars and needs of the modern organization In order to fulfill all the requirements that the market imposes ERP has become an useful utility The general ledger tasks are nowadays one of the most important activit
 

What is Comprehensive Data Definition

A Comprehensive Data Definition refers to a formal data definition that provides a complete, meaningful, easily read, readily understood definition explaining the content and meaning of data. In a business enterprise environment where people are heavily depending on intelligent business systems (bus
 

What happens when a variable is not declared in function definition?

Generally in C program the function definition and calling takes the form as given below: main() { int x,y,z; z=sample(x,y); printf(“%d”,z); } sample(x1,y1) int x1,y1; { int z1; z1= x1 - y1; return(z1); } Here what happens is the values x, y gets passed to x1,y1
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape