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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the concerns of OLTP and DSS systems?

2450


What is tracing level?

1075


Define Dynamic push down optmization?

2309


How to fine tune mappings?

946


What are the differences between sql override and update override?

1105


Explain the use lookup tables and Aggregate tables?

978


Explain about the data integration suite features?

954


where we cannot use sorter Transformation. if we use then we will not get correct data?

2201


what is the use of server?

2203


How to delete data which is not in source table?

1347


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2244


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2487


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

2021


Explain etl mapping sheets?

1082


explain the methodology of Data Warehousing?(Polaries)

2300