Answer / rahul

for n source we required n-1 joiner t/r.

ex: if we have 3 flat file dan we requried 2 joiner t/r

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

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

1 Answers   HCL, IBM,

---

What are the types of caches in lookup?

0 Answers  

---

How to delete duplicate row using informatica?

0 Answers  

---

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 size of your data warehousing?

0 Answers   IBM,

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

In Which scenario did u used Incremental loading?

2 Answers  

---

What are two types of processes that informatica runs the session?

2 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---