hi this is madhu
i have one doubt,regarding siebel
Q: is this is mandatory when we r doing join between a bc &
table , the table should extension table Reqired or not, can
we do the join with base table also,
Answer Posted / vishnu
Hai,
i follwed your argument............
What you mean to say........
the thing is siebel have two type of joins .. implicit and
explicit..
we know that joins needs a extra query for the fetching
data from other table.. so it impacts the performance. so
siebel is provided implicit joins that having relation ship
with base table 1-1. But it also needs extra query for the
fetching data for siebel. but those queries are normalised.
SO it improves the performance.
And generally we have to establish join between buscomp and
tables. SO its not important that whether base or extention.
the thing inter table lies orphan. that does not contain
any buscomp when we establish link between buscomps then
the intertable columns establish implicit relatioon ship
with in the buscomp. so we can directly fields .its also an
advantage of using intertable..
and
Now iam givng some examples you need to practice for
just contact buscomp to currency Table
establish relashion ship with Join
the above is very easy task..
if you follow another assignment. Contact and Industry.
its some what tricky if you do this you can understand tht
what behind the logic contain for the join..
all the best..
in above examples the join is buscomp to base table..
All the best.. friend
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to refresh an asp page on a single click of a button?
Can we Use VB SCRIPT instead of JAVASCRIPT in Asp.Net...
Explain the differences between asp and asp.net and is asp.net backward compatible to asp?
Explain the post & get method or explain the difference between them in asp?
How do I make it so that code runs when the security system is stopping it?
Define common language specification (cls)?
How do you initialize a two-dimensional array that you don't know the dimensions of?
What is pdf aspx?
i am creating an e-learning site, i want my customers to pay directly through paypall to my paypall account directly from my page ? is it possible ? is there any ready paypall script ?
What is asp contentplaceholder?
Name the event handlers of application object?
Explain how do you initiate a string without escaping each backslash?
What is the purpose of application.lock method?
What are the 3 types of internal controls?
What is a request body?