Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

---

---

how can u load the data in time dimension?

3 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

What are parallel querys and query hints?

1 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

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,

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---