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


Please Help Members By Posting Answers For Below Questions

How big was your fact table

1310


How can a transformation be made reusable?

658


explain abt ur project architecture?

1758


What is InformaticaPowerCenter?

681


Explain the mapping variable usage example in informatica

629






what are the deliverables?in your project?

1655


How union transformation is used?

589


In which transformation you cannot drag ports into it?

776


What are the new features of informatica 9.x in developer level?

553


Explain sessions and how many types of sessions are there?

578


What is fact table? Explain the different kinds of facts.

610


On which transformations you created partitions in your project?

759


wat are deployement groups in informatica, how it will be used for developers

1249


Mention a few design and development best practices for informatica?

555


How to do unit testing in informatica? How to load data in informatica ?

645