Answer / anilchandu

Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.

The main advantage of stored procedure t/r is the code
reusability.

Answer / swetha

For populating and maintaining data bases.

Answer / rajbir

We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment

Answer / madhu

For best performance

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

How is Data Models Used in Practice?

1 Answers  

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

what are surrogate keys?

5 Answers  

---

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

In how many ways we can create ports?

0 Answers  

---