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 incremental aggregation?
What is a passive transformation?
How do you update the records with or without using update strategy?
What is meant by incremental aggregation?
Explain pmcmd command usage in informatica
What is a difference between complete, stop and abort?
Where is metadata stored?
Implementation methodology
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is persistent lookup cache?
What is meant by query override?
What do you mean incremental aggregation?
What does cheating measurement mean?
What are the differences between joiner transformation and source qualifier transformation?
How can you generate reports in informatica?