How to Join Tables my Source is having 15 table target is one?

How to Join Tables my Source is having 15 table target is
one?

Question Posted / deva_dwh

4 Answers
7004 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Join Tables my Source is having 15 table target is one?..

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.

Is This Answer Correct ?

6 Yes

1 No

How to Join Tables my Source is having 15 table target is one?..

Answer / narender_kusa

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

Is This Answer Correct ?

4 Yes

1 No

How to Join Tables my Source is having 15 table target is one?..

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)

Is This Answer Correct ?

3 Yes

0 No

How to Join Tables my Source is having 15 table target is one?..

Answer / balu024

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer