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
- 15856 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 |
What are materialized views & where do we use them?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are the various tools used in etl?
Hi, Lookup() is what kind of join ?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
what are business components in Informatica?
What is the difference between Data Warehousing and Data Mining?
what is the meaning of upgradation of Repository?
Can there be sub steps of etl steps?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Teradata 
