IQD generated in FM and Joins

Hi

I have generated IQD for each individual table in my database layer in FM.My question is how will the joins treated as each IQD is showing a single table select.Its not showing any joins.

Even if i create IQD from my business layer where all the tables related to product are grouped together
the IQD will show joins for product and its related tables.The question is how transformer will come to know what is the join between product and sales ???

Ans - It will come to know the join based on column names.There should be a common column between both sales and product

make join between iqds you have to use the same column name. Let say you have two iqd :

One for customer containing :
Customer Id
Customer Name
...

One for Orders :
Order Id
Customer Id
Product Id
Amount
...

The join between these iqds will be "Customer Id". You can change the name of the column in the property tab of the field.

How will you solve issues like loop in tranformer ?Suppose product ,sales ,country form a loop.How will this be solved .