wat s mapping parameter and mapping variable? how do you
set that in a mapping?
- 3 Answers
- 7330 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 |
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What happens when a session fails and you click on recover?
Describe data concatenation?
how can run the wf through pmcmd commend? write script?
Enlist some properties of sessions.
What are the circumstances that infromatica server results an unreciverable session?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
How will you check the bottle necks in informatica? From where do you start checking?
How many number of sessions that u can create in a batch?
Enlist the various types of transformations.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Teradata 
