Interested to Buy Any Domain ? << Click Here >> for more details...
Can yoU use the maping parameters or variables created in
one maping into another maping?
- 2 Answers
- 7109 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
NO. We can use mapping parameters or variables in any
transformation of the same maping or mapplet in which yoU
have created maping parameters or variables.
| Is This Answer Correct ? | 7 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
Informatica Checkpoints
What is an expression transformation in informatica?
What are the types of data warehouses?
What is the function of aggregator transformation?
r u done any partitions in ur project?
What are the modules in Power Center
What are the performance considerations when working with aggregator transformation?
Explain sessions. Explain how batches are used to combine executions?
How many number of sessions can one group in batches?
What is target load order?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a standalone command task?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
explain abt ur project architecture?
