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 are the different types of transformation available in informatica.

854


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1080


Partition, what happens if the specified key range is shorter and longer

2244


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1890


In how many ways we can create ports?

922


how tokens will generate?

1972


what is diff b/t sorter t/r and agg have the option sorter property...

1972


Which transformation is needed while using the Cobol sources as source definitions?

978


What is an expression transformation?

838


What are the types of schemas we have in data warehouse.

751


update strategy transformation in informatica

863


What are the components of Informatica? And what is the purpose of each?

846


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1499


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

852


How to update source definition?

882