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
- 8159 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 the difference between STOP and ABORT options in Workflow Monitor?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
Is stop and abort are same in informatica?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Can yoU use the maping parameters or variables created in one maping into another maping?
Enterprise data warehouse your projects phase by phase explain?
How to convert flat file into xml file? How to tune joiner?
Explain factlessfact table with scenario
disable caching in a lookup transformation?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
what is the hint? how to use it to reduce the query processing in program?
How can we handle two sessions in informatica?
Teradata 
