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



How can u work with remote database in informatica?did you work directly by using remote connection..

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

How can u work with remote database in informatica?did you work directly by using remote connection..

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

Post New Answer

More Informatica Interview Questions

What is a command that used to run a batch?

4 Answers  


"Change cache" in Informatica ?

2 Answers  


How we can use union transformation?

0 Answers  


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


What do you mean by blocking transformation?

0 Answers  


I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  


What is a code page?

0 Answers  


what is curr val use for in sequence generator?

2 Answers   Emphasis,


What is parallel processing in informatica?

0 Answers  


Categories