How can u work with remote database in informatica?did you
work directly by using remote connections?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rekha
By using UNIX command i.e
$ ftp m get filename we can import the remote database
into our local system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
Separate from an archive server and a powerhouse?
Mention a few design and development best practices for informatica?
What is predefined event?
Router T/R is active but some people are saying it is also passive which is exactly right?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
what is filelist concept in informatica
What is main use of mapplet?
What is partioning?how many types of partinings are there
what is the necessity to use update strategy?(except for updates)
what is shortcut in informatica? difference between shortcut,reusable object?