Answer / ysindhureddy77@gmail.com

A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.


A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.

 From the Session parameter file
 As stored in the repository object in the previous run
 As defined in the initial values in the designer
 Data type Default values

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

How can informatica be used for an organization?

0 Answers  

---

What is workflow monitor?

0 Answers  

---

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

How mapping parameter and variable works

1 Answers  

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---