In real time scenario where can we use mapping parameters
and variables?
- 4 Answers
- 30943 Views
- CSC, CSE, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pendekanti praveen kumar
Before using mapping parameters and mapping variables we
should declare these things in mapping tab of mapping
designer.
A mapping parameter cannot change untill the session has
completed unless a mapping variable can be changed in
between the session.
Example:::
if we declare mapping parameter we can use that parameter
untill completing the session,but if we declare mapping
variable we can change in between sessions.Use mapping
variable in Transcation Control Transformation......
| Is This Answer Correct ? | 40 Yes | 7 No |
Answer / bsgsr
mapping variable unlike mapping parameter changs its value
during session execution. it is used in incremental loading.
parameters are used in many scenarios like loading the data
of employees who joined ina particular year, for
timestamping, loading the data related to a particular
product id. alike.
if i am wrong let me know.
bsgsr12@gmail.com
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / ram kumar
Mapping & Mapplet, v can use the mapping parameter &
variable. V can also create the parameter & variable in the
sesssion level.
| Is This Answer Correct ? | 31 Yes | 23 No |
Answer / kittu
Before using mapping parameters or variables first we hav to declare them in mapping level.After that we can create parameter file with .txt or .prm extension . Mapping parameters are used when the requirement need the values that cannot change with in session where as mapping variables can change the value with in session the best example for mapping variable are we can use them in concept of Increamental Loading and also to generate sequence numbers with out using sequence Generator Transfomation.
| Is This Answer Correct ? | 7 Yes | 4 No |
What is the role of informatica in project ?Like i showed financial projects?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to merge First Name & Last Name?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is the mechanism of the Master-Detail joining condition?
What are the new features of informatica 9.x in developer level?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
What is meant by target load plan?
What is Collect performance data in informatica and what is the use of it.
During the running session, output files are created by informatica server. Enlist few of them.
Teradata 
