Interested to Buy Any Domain ? << Click Here >> for more details...
what are variable ports and list two situations when they
can be used?
- 4 Answers
- 15740 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
list and discuss two approaches for updation of target table in Informatica and how they are different.
can cubes contain measures ?
Explain different types of partitioning?
what is the difference between date cache and lindex cache?
what is granularity in Data ware House?
What is a mapping, session, worklet, workflow, mapplet?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
Which type or t/s is used to convert rows into column & column into rows
what is session partitioning?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
what is Forward,Reverse and Re_engineering?
Teradata 
