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

Explain how many types of dimensions are available in informatica?

0 Answers  

---

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

---

What is informatica worklet?

0 Answers  

---

What is xml source qualifier transformation in informatica?

0 Answers  

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

Why filter transformation is an active one?

0 Answers  

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---