what are variable ports and list two situations when they
can be used?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1557


how do u identify the changed records in operational data?

2135


what is the meaning of upgradation of Repository?

3296


What are the key benefits of ETL Testing?

563


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1666






A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1824


Identifying the bottlenecks in various components of Informatica and resolving them.

1503


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3312


Explain the difference between etl tool and olap tools?

533


What is full load & incremental or refresh load?

683


how do u handle performance issues in Informatica . where can u monitor the performance ?

4266


what are the data modeling tools you have used?(polaris)

1545


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1755


dimension object created in oracle can be imported in designer?how?

2453


How to increase performance without changing anything in mapping.( In prod)

782