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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the data movement modes in informatica?
What is a joiner transformation and why it is an active one?
what is informatica metadata?
What is the command used to run a batch?
Explain the informatica workflow?
Write the program through which the records can be updated?
How do you load first and last records into target table?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are junk dimensions?
How are indexes created after completing the load process?
How to generate sequence numbers using expression transformation?
is it possible to index the data in cache of lkp transformation ?
What is native users?