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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in etl process?

515


What is partitioning? Explain about round-robin, hash partitioning.

547


Explain what are the various etl tools in the market?

517


Can there be sub steps of etl steps?

531


What is staging area referring to?

574






What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

551


Define slowly changing dimensions (SCD)?

613


what are the concerns of OLTP and DSS systems?

1969


What are the different Lookup methods used in Informatica?

518


What is a lookup table in etl?

594


if i have a query as flat file how can we load data to target table

974


what are the reports developed in sap bw project and what is the requirement for developing it?

1774


What is a mapping, session, worklet, workflow, mapplet?

508


What are three tier systems in etl?

619


What is the difference between round-robin partitioning and hash partitioning?

544