Answer / suneel kumar

First of all which type of sources yiu are using.
1)If all source types are same type of databases you can go
for joiner or SQ
2)If sources are diff types of databases u should go for joiner.

Answer / narender_kusa

if u have n sources u need n-1 joins..

Answer / moorthy g (ibm)

If your source is Flat file and Same Strcture then you can
go for indirect file type.
If source is relation file the you can use Source
Qualifier - Sql override or join condtion.
or Joiner Transformation(n-1)
=====
We Can join those tables in DB level.
(For Performance Tuning)

Answer / balu024

if you have same meta data in all 15 tables, then you can join
those tables by using union transformation

how can we use sorter transformation in joins?

5 Answers   IBM,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

How many number of sessions can one group in batches?

0 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

Briefly describe lookup transformation?

0 Answers  

---

What is meta data and system catalog?

2 Answers  

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

---