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 |
Mapplets can you use an active transformation in a mapplet,
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Why sorter is an active transformation?
difference between stop and abort
How to elaborate powercenter integration service?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What are the guidelines to be followed while using union transformation?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
what is plsql table?
what are surrogate keys?