How can you access the remote source into your session?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is intricate mapping?

594


What is aggregator transformation in informatica?

545


Can we create a node as a gateway node and the same node can be assigned to a grid?

641


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5585


What is a transaction control transformation?

768






Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

784


How to handle decimal places while importing a flatfile into informatica?

727


What are the modules in Power Center

1240


Explain the shared cache and re-cache?

613


Why is sorter an active transformation?

667


What is the use of code page?

610


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

618


What is a surrogate key?

563


Can we override a native sql query within informatica?

632


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)

1088