Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we join the tables if they don't have primary and
foreign key relationship and no matching port?

Answer Posted / kishore

Very Simple guys....

Do a Override in SQ:

Select * from Tab1, Tab2

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1135


What are the restrictions of union transformation?

1044


What is deployment group?

1218


Why do you use Mapping Parameter and mapping variable?

1769


What are the transformations that are not supported in mapplet?

1033


What are ETL Tools?

1122


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2174


my source is junk data how will u remove that junk data by using unix please any one replay me

3704


What is the sequence generator transformation in informatica?

1185


What is the meaning of decode in informatica?

1122


Explain sessions. Explain how batches are used to combine executions?

1034


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1133


What are batches?

1102


Explain what are the different versions of informatica?

1100


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1635