How can u work with remote database in informatica?did you
work directly by using remote connections?
- 2 Answers
- 7750 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
To work with remote datasource u need to connect it with
remote connections. But it is not preferable to work with
that remote source directly by using remote connections
.Instead u bring that source into U r local machine where
informatica server resides. If u work directly with remote
source the session performance will decreases by passing
less amount of data across the network in a particular time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rekha
By using UNIX command i.e
$ ftp m get filename we can import the remote database
into our local system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
In dimension and fact table? which one holds big data?
If you want to create indexes after the load process which transformation you choose?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
What does cheating measurement mean?
wf dont have integration severances how you can run?
how many session run unix environment what command using ?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How i can upload the MainFrame source For Informatica ?
Explain the use of aggregator cache file?
Why we need XMLs?
Teradata 
