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 you join two tables without any common column present in them?



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

Answer / 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

More Informatica Interview Questions

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,


what is the gap analysis?

1 Answers  


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


How to handle decimal places while importing a flatfile into informatica?

0 Answers  


Describe data concatenation?

0 Answers  


how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


Is stop and abort are same in informatica?

0 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


What is joiner change?

0 Answers  


Categories