How can you access the remote source into your session?
Answer / 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 |
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is rank transformation in informatica
How to update a particular record in target with out running whole workflow?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Explain sessions. Explain how batches are used to combine executions?
how can run the wf through pmcmd commend? write script?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
explain about unit testing? in real time?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15