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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How can you join two tables without any common column present in them?

Question Posted / lisa

Answer Posted / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

1131

How are indexes created after completing the load process?

1713

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1156

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1116

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1014

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2100

Different qualification between a related rotate toward the sky and isolates look upward?

1032

What is deployment group?

1289

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1948

What is informatica powercenter repository?

1253

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1147

Explain transaction control transformation in informatica

1304

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2016

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1811

Under what condition selecting sorted input in aggregator may fail the session?

1170