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
What is intricate mapping?
What is aggregator transformation in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
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?
What is a transaction control transformation?
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?
How to handle decimal places while importing a flatfile into informatica?
What are the modules in Power Center
Explain the shared cache and re-cache?
Why is sorter an active transformation?
What is the use of code page?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a surrogate key?
Can we override a native sql query within informatica?
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)