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

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,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

How do you handle decimal places while importing a flatfile into informatica?

1 Answers  

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

How mapping parameter and variable works

1 Answers  

---

What is a repository manager?

0 Answers  

---

What are the different lookup cache(s)?

0 Answers  

---