Answer / abhinaw prakash

In Mapping parameter the value once defined does'nt change
during the session.Once the session completes successfully
the server again reads the data from the beginning.

In mapping variable the value changes during the session and
after the session completes the integration server reads the
data from the last saved value from the last run.

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

Enlist the various types of transformations.

0 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---