Interested to Buy Any Domain ? << Click Here >> for more details...
what are the perameter and variable?
- 3 Answers
- 8151 Views
- IBM, I also Faced
- E-Mail Answers
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 |
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Do you have to change the reject file b4 using reject loader utility.
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
In update strategy target table or flat file which gives more performance ? why?
when we go for unconnected lookup transformation? and why?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
During the running session, output files are created by informatica server. Enlist few of them.
When you move from devel to prod how will you retain a variable
Can you start a session inside a batch individually?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
How to join three sources using joiner? Explain though mapping flow.
How to eliminate duplicate records in informatica mapping? Explain with an example....
Teradata 
