what are variable ports and list two situations when they
can be used?
- 4 Answers
- 13965 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 |
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is session partitioning?
What are the modules in Power Mart?
how do u handle performance issues in Informatica . where can u monitor the performance ?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
What exact we can see in table?
what is Forward,Reverse and Re_engineering?
What is a staging area? What is the purpose of a staging area?
What are various etl tools in the market?
Can u access a repository created in previous version of Informatica?
What is grain of fact?
Teradata 
