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

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What is repository manager?

0 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---

How do you take care of security using a repository manager

2 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---