what are variable ports and list two situations when they
can be used?
Answer Posted / 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 |
Post New Answer View All Answers
When do we go for the tools in the market?
How etl testing is different from database testing?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are cubes and olap cubes?
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
Explain the difference between etl tool and olap tools?
How can we use external procedural logic in informatica?
What is the difference between Data Warehousing and Data Mining?
when will use SQL override in a lookup transformation?
what is data modeling?
what is pmrep command?
Explain do we need an etl tool?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the modules in Power Mart?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?