Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

By seeing the parameter file how do u identify wheather it
is a workflow parameter or mapping parameter?

Question Posted / rakesh

Answer Posted / rakesh

Variables which has "$$" as prefix are the Mapping variables.
Variables which has "$" as prefix are the Session variables.
Variables which has "$$$" as prefix are the system defined variables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data-driven sessions?

947

What is a transaction control transformation?

960

Where do we use mapping variables in informatica?

809

What are the limitations of joiner transformation?

854

What is workflow? What are the components of workflow manager?

920

What is rank transform?

754

What is a filter transformation and why it is an active one?

767

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1907

What is lookup change?

818

What is sq transformation?

850

What is update strategy transform?

800

Explain sql transformation in script mode examples in informatica

799

What are the types of caches in lookup?

776

Define the various join types of joiner transformation?

775

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

8436