How can you access the remote source into your session?



How can you access the remote source into your session?..

Answer / swetha

Relational source: To acess relational source which is
situated in a remote place , you need to configure database
connection to the datasource.

FileSource : To access the remote source file you must
configure the FTP connection to the host machine before you
create the session.

Hetrogenous : When your maping contains more than one
source type,the server manager creates a hetrogenous session
that displays source options for all types.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is sql query override? When did u use sql query override?

1 Answers   TCS,


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


How can we delete duplicate rows from flat files?

0 Answers  


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,






What differs when we choose the sorted input for aggregator transformation?

0 Answers  


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


What is the difference between a router and a filter transformation?

1 Answers   TCS,


What is native users?

0 Answers  


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


What is the session task and command task?

0 Answers  


Categories