How can u work with remote database in informatica?did you
work directly by using remote connections?
Answer Posted / swetha
To work with remote datasource u need to connect it with
remote connections. But it is not preferable to work with
that remote source directly by using remote connections
.Instead u bring that source into U r local machine where
informatica server resides. If u work directly with remote
source the session performance will decreases by passing
less amount of data across the network in a particular time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a surrogate key?
what are 3 tech challenges/ common issues you face?
What is rank transform?
How can you differentiate between powercenter and power map?
Explain pmcmd command usage in informatica
whats the logic to load the lower level of granularity of data to fact table.
What is the difference between Active and Passive transformation?
What is an aggregator transformation?
What are junk dimensions?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Design a mapping to load a target table with the following values from the above source?
How to generate sequence numbers?
What is the session task and command task?
What are the tasks that source qualifier perform?
Enlist the various types of transformations.