What is the Lookup's and what is the use of lookup's?
Answers were Sorted based on User's Feedback
Answer / kranthi kumar
Lookups are referred in more locations.
instead of storing the original value,we can store the
lookup codes.
this will reduce the space that is occupied in the database.
this is one reason.
the main reason is..
take an example...
in a table xx_emp there is one column gender.
possible values are
male m
female f
other o
define the above values in a lookup.
if u want to change the male to female ..u go and update
the lookups then automatically all the records referring to
that lookup will also change dynamically...
This saves time and complexity.
hope this clears the above question..........
Is This Answer Correct ? | 42 Yes | 1 No |
Answer / shagul
Lookup's are generally used to refer the values ,
assume job , Manager alias MGR assign as lookup codes,
lookups are table values , if need to change just update the
MGR it ful fill the updatation,
update the look up
it ll saves times and complicity
hope u got the answer
Is This Answer Correct ? | 8 Yes | 5 No |
Lookups are the tables where the client expected format is
found.
For example if we get the data like 'PROJECT MANAGER' and
the client wants that in the 'project manager' then these
lookups are used.
Is This Answer Correct ? | 8 Yes | 20 No |
Do you know where we can check the status of po?
In custom.pll what are the events we can Not write.
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
What are the benefits of using soa architecture?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
what is the use of anchors?
List the types of flexfield?
Can you define an erp system?
Can anybody tell me, What is the Implementation Process?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????