can session assigned multiple mappings or not?
Answer Posted / rakesh
Session represents only one mapping. It makes the mapping available to the workflow for execution.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
On which transformations you created partitions in your project?
What is a passive transformation?
without table how to come first record only in oracle?
How do you promote a non-reusable transformation to reusable transformation?
What is lookup transformation?
What is the Process to creating lookup transformation in 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
What is difference between a gateway node and worker node?
Briefly define a session task?
What are the main features of Oracle 8i with context to datawarehouse?
How to implement security measures using repository manager?
How do you load unique records into one target table and duplicate records into a different target table?
How to update a particular record in target with out running whole workflow?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the different transaction levels available in transaction control transformation?