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

what are the types of facts with Examples?

3 Answers  

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

What do you mean incremental aggregation?

0 Answers  

---