srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 10th, 2006

 

9 joiners are required to join 10 different sources.

satish

• Nov 10th, 2006

 

9 joiner needed

shail

• Nov 13th, 2006

 

8

anjee

• Nov 15th, 2006

 

can u say how we can join 10 sourses with only 8 joiners? i feel it is (n-1) joiners for n sourses. please send me the answer to my email id.

  thanx

lalendra

• Nov 16th, 2006

 

total 9 joiner because total source 10 then (n-1)

jvivek80

 Profile Answers by jvivek80 

• Dec 25th, 2006

 

Basically we can have only a joiner transformation for max of two different sources only. This joiner transformation can be linked to another source in another joiner transformation and so on. So, if we have n different sources the remainning n-2 sources will have n-2 transformations. Thus a total of 1+(n-2) transformations = n-1.

Tapas

• Oct 6th, 2007

 

That depends on whether the sources are homogenous, coming from same database or not.
If they are tables in the same database, you can join multiple tables using the SQ.
If you cannot join in the SQ, and you only want to use JNR transformations, then the answer is n-1

Rajasekhar V

• Sep 7th, 2011

 

9 joins why because we have to join 10 tables we can use "N-1" joins so(10-1=9) 9 joins are used

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 7th, 2011

 

N-1 formual works so 10-1=9 joiner transformations required

venkatesh

• Sep 7th, 2011

 

one joiner transformation

mani

• Sep 7th, 2011

 

its n-1, so you need 9 transformations.