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 are roles and groups and benefits of using them?

0 Answers  


What is joiner transformation in informatica?

0 Answers  


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

1 Answers   TCS,


What is the benefit of partitioning a session?

0 Answers  


What is query panel?

1 Answers  


how will you get 21 to 30 record from 50 records?

6 Answers  


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


why u go for dimensions ?

3 Answers   TCS,


Can you use flat files in Mapplets.

0 Answers  


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,


Explain the different kinds of facts.

0 Answers  


Categories