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 to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Answers were Sorted based on User's Feedback



how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / guest

we can join two table by using source qualifier t/r

Is This Answer Correct ?    7 Yes 1 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / swathi

using source qualifier and also lookup transformation,

joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More ETL Interview Questions

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers   Accenture,


What are the different etl testing categories as per their function?

0 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


What is lookup table in etl testing?

0 Answers  


What is the difference between round-robin partitioning and hash partitioning?

0 Answers  


How etl testing is different from database testing?

0 Answers  


how do use session mapping parameters ?(in which transformation)

0 Answers  


how do u set partition points in the mapping?

0 Answers   Quintiles,


What exact we can see in table?

1 Answers  


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


how do u implement configuration management in Informatica?

0 Answers  


Categories