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

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'.

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

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

what is runtime variable?

3 Answers   TCS,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---