How can you access the remote source into your session?
- 1 Answers
- 5842 Views
- I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? How do we do it?
What is DR strategy for Informatica project?
What is lookup change?
How to open an older version of an object in the workspace?
Mention a few design and development best practices for informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Explain joiner transformation in informatica
What is the function of aggregator transformation?
what are the deliverables?in your project?
What is session task and command task?
Under which circumstances, informatica server creates reject files?
Explain why we use partitioning the session in informatica?
explain abt ur project architecture?
explain one complex mapping with logic? sales project?
What is the procedure for creating independent data marts from informatica 7.1?
