In real time scenario where can we use mapping parameters
and variables?
- 4 Answers
- 30532 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 ? | 39 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 |
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is casual dimension?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Which will beter perform IIf or decode?
State the differences between sql override and lookup override?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Define sessions in informatica etl?
Teradata 
