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

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---