what are variable ports and list two situations when they
can be used?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Identifying the bottlenecks in various components of Informatica and resolving them.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is the meant by Normalization and de-normalization?
explain the methodology of Data Warehousing?(Polaries)
What are the key benefits of ETL Testing?
if u can't find what you are looking for in lookup table, how do you handle?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Eliminating of duplicate records without using dynamic lookups
what are Lookup caches options? Including persistent caches.
Need Informatica Power Center 9.1 free download(for all windows version)
List few etl bugs?
Explain about power designer data modeling software?