Answer / raj

For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.

Answer / sunil reddy

Thankd for your reply.

Could you please explain me about transaction code?

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---