Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
this is venu, New to QV
Applymap is better than joins in One to One relation...
for why?
wHAT ARE THE MAJOR DRAWBACKS OF JOINS?
THANKS IN advance
VEnu
Joins will result in bigger table, increasing the size...
applymap will just fetch values from one table to another, applymap will work like lookup just adding one column to what is already existing but join will join both the tables so the number of lines will increase(not actually what was there in the first table alone)
-Sundar
PFA white paper that explains joins and applymap in detail.
-Sundar