For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

Explain grouped cross tab?

1 Answers   Accenture,

---