what are variable ports and list two situations when they can be used?

what are variable ports and list two situations when they
can be used?

Question Posted / jakki

4 Answers
15710 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are variable ports and list two situations when they can be used?..

Answer / pooja ahmed

variable ports can be created in many trans.... the value
of the values will be used only with in that trans...

porpuse: to store the values n to perfoorm cal

for ex: in exp we take variable port to cal the
caluation.like sal+comm
or decode( partcost< 100,y,s)

Is This Answer Correct ?

2 Yes

0 No

what are variable ports and list two situations when they can be used?..

Answer / swathi

the ports which can change its value at run time and stores
temporarily are called as varible ports.

1)one important use in real time is,using varible
ports we can return multiple ports in unconnected stored
procedure.generally unconnected returns single port only.
2)if u create one port as variable port,we can use
this port in writing expressions and also assigned to any
no.of output ports

Is This Answer Correct ?

2 Yes

0 No

what are variable ports and list two situations when they can be used?..

Answer / bsgsr

a variable port is one which is executed after the input
port or before the output port.

the order of xecution of the ports
input, variable , output

while doing incremental loading v use variable port
while while doing any count with the source tables

Is This Answer Correct ?

1 Yes

0 No

what are variable ports and list two situations when they can be used?..

Answer / maruthi

VARIABLE PORT-WHCIH WE CAN CREATE IT IN MANY
TRANSFORMATIONS FOR VARIABLE CALCULATION PURPOSE.
CREATE ANY NEW PORT IN AGGREGATION AND USE IT TO
CALCULATE MAX(SAL) OR ANY OTHER CALCULATION,THEN IT BECOMES
VARAIBLE PORT.
IT IS CALLED AS VARABLE PORT ,BECOAUSE IT IS VALUE WILL BE
KEEP ON CHANGING AS THE ROWS ARE KEP ON CHANGING.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer