Interested to Buy Any Domain ? << Click Here >> for more details...
wat s mapping parameter and mapping variable? how do you
set that in a mapping?
- 3 Answers
- 8237 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chinna
A mapping parameter represents a constant value that you
can define before running a session. A mapping parameter
retains the same value throughout the entire session.
Unlike a mapping parameter, a mapping variable represents a
value that can change through the session. The PowerCenter
Server saves the value of a mapping variable to the
repository at the end of each successful session run and
uses that value the next time you run the session.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raja
mapping parameter represents a constant value ,u decleare
these values at a file and store at a location ,the path
will be declared at session properties and the parameter
name is declered at designer->parameters&variables ----
naming convention is $$-----.when u run the session then it
will take the values from the file
variables ---declearing as same above but for parmeter we
wil declear it as parameter n 4 variable we decler it as
variable ---functionality if u declare it as last updated
date for first run it will take as intial value which u
declare and it wil save that date and for next it wil date
that previous run value -like that---u can ask any thing 4
further mail me at tiger.jagan.ys@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / basha
Mapping parameter is a parameter whose value does not change
through out the session run.This will take the value from
the parameter file.
Mapping variable value will be saved by session so this
value can be used from the next sessions runs.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
All active transformations r passive or not?
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?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the difference between bitmap and btree index?
What are the session parameters?
What is a dimensional model?
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 the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
How you know when to use a static cache and dynamic cache in lookup transformation?
Teradata 
