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

What is domain in terms of informatica?

0 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


Explain factlessfact table with scenario

1 Answers   HCL,


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


When the informatica server marks that a batch is failed?

2 Answers  


Explain what are the different versions of informatica?

0 Answers  


Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  


Categories