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 are the different types of transformation available in informatica.
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.
Partition, what happens if the specified key range is shorter and longer
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
In how many ways we can create ports?
how tokens will generate?
what is diff b/t sorter t/r and agg have the option sorter property...
Which transformation is needed while using the Cobol sources as source definitions?
What is an expression transformation?
What are the types of schemas we have in data warehouse.
update strategy transformation in informatica
What are the components of Informatica? And what is the purpose of each?
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.
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?
How to update source definition?