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 |
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the advantage of informatica?
What are the out put files that the informatica server creates during the session running?
What is diff joiner and lookup
how to create a sample mapping for dynamic lookup transformation
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
If we have lookup table in workflow how do you trouble shhot to increase performance?
Mention few power centre client applications with their basic purpose?
What is power center repository?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
what is diff b/t sorter t/r and agg have the option sorter property...