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 |
Eliminating of duplicate records without using dynamic lookups
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.
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
How many types of transformations supported by sorted input?
What is etl tool in hadoop?
working of line item dimension......pls,tell overall flow
what are the data modeling tools you have used?(polaris)
what is the difference between OLTP database and data warehousing database?
what is the difference steps for data modeling?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
without using ETL tool can u prepare a Data warehousing and maintaining?