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
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.
how do u identify the changed records in operational data?
what is the meaning of upgradation of Repository?
What are the key benefits of ETL Testing?
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 ?
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?
Identifying the bottlenecks in various components of Informatica and resolving them.
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?
Explain the difference between etl tool and olap tools?
What is full load & incremental or refresh load?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what are the data modeling tools you have used?(polaris)
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?
dimension object created in oracle can be imported in designer?how?
How to increase performance without changing anything in mapping.( In prod)