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

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


Briefly define a session task?

0 Answers  


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,


Differentiate between mapping parameter and mapping variable?

1 Answers  






how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


plz plz plz send client names and project names in informatica?

1 Answers  


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


Categories