Answer / ramu

the informatica server follows instruction coded into update
strategy t/r with in the session mapping determine how to flag
records for insert,update,delete or reject if you do not
choose datadriven option setting the informatica server
ignores all update strategy t/r in mapping.

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

What is predefined event?

1 Answers  

---

Why we use lookup transformations?

1 Answers  

---

how to load duplicate row in a target

4 Answers  

---

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

Explain lookup transformation in informatica

0 Answers   Informatica,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

How to generate sequence numbers?

0 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---