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  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

---

What is a stored procedure transformation?

0 Answers  

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

explain about session partitions ?

1 Answers  

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

What is A complex mapping?

3 Answers   TCS,

---

Where is metadata stored?

0 Answers  

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---