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?

Why we use partitioning the session in informatica?

2 Answers  

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

What is the meaning of decode in informatica?

0 Answers  

---

What are the new features in Informatica 5.0?

1 Answers  

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

What is lookup transformation?

0 Answers  

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---