Sign Up Login


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

How can we use mapping variables in informatica? Where do we use them?

Question Posted / vikas agarwal

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

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

4 Answers   CSC,

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

What are the designer tools for creating transformations?

0 Answers   Informatica,

tell me the rules and responsblites in our project(my project is development)

0 Answers  

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,




State the differences between sql override and lookup override?

0 Answers  

Differences between connected and unconnected lookup?

0 Answers  

Where do you create/define mapping parameter and mapping variable?

1 Answers  

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

How to recover the standalone session?

2 Answers  

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

For more Informatica Interview Questions Click Here
Categories