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

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

---

Is stop and abort are same in informatica?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

All active transformations r passive or not?

7 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---