what are the perameter and variable?
Answers were Sorted based on User's Feedback
Answer / bsgsr
parameter and variables used in the mappings indeed make
them reusable incase a single element of the mapping needs
to be changed. This way it saves the dev time to build the
whole mapping again.
parameter once defined and value is assigned will not
change its value during the session run.
Unlike parameter, a variable changes its value through out
the session run.
this is my prception of the question.
kum lets share knowledge and help one another find a break
with the industry. U feel so reach me on bsgsr12@gmail.com
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / jang
Mostly Parameters are used, where u want mapping to do
Change Data Capture, here we use the Source port value
compare against Parameter value in SQL override of SQ TRN.
Once this WFl completes , immd...then update the parameter
value using other WFL.
The syntax to declare a Parameter is
[Foldername.WF:workflowname.ST:sessiontaskname]$$parametername
='date value' or 'value'.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kammari.krishnaiah
hi this is krishna
my answer is variable is which varies the value means changes.
perameter is a stores the value it cant change the value
Is This Answer Correct ? | 0 Yes | 1 No |
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
why union transformation is active transformation?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
What does cheating measurement mean?
What is target update override
Can informatica load heterogeneous targets from heterogeneous sources?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
If I have a index defined on target table and if set it to bulk load will it work ?
Implementation methodology
What is the difference between Bitmap and Btree index?
Explain the different lookup methods used in informatica?
what are the settiings that u use to cofigure the joiner transformation?