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

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

Define informatica repository?

2 Answers   Wipro,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

What are the joiner caches?

3 Answers   Informatica,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---