what are the reusable tasks in informatica ?
- 11 Answers
- 51429 Views
- CTS, HP, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / hari
Session Task,
Email Task,
Command Task
Worklet
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
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
What is olap (on-line analytical processing?
What are the different components of powercenter?
What is the difference between informatica 7.0 and 8.0?
How to update a particular record in target with out running whole workflow?
How to do the error handling of if ur source is flatfiles?
Explain the scenario which compels informatica server to reject files?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is source qualifier transformation in informatica?
How can a transformation be made reusable?
How to elaborate tracing level?
What is mapplet in informatica?
Explain how many types of dimensions are available in informatica?
how tokens will generate?
Target increases every day even though no new record was inserted
