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
what are the concerns of OLTP and DSS systems?
What is tracing level?
Define Dynamic push down optmization?
How to fine tune mappings?
What are the differences between sql override and update override?
Explain the use lookup tables and Aggregate tables?
Explain about the data integration suite features?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is the use of server?
How to delete data which is not in source table?
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?
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
how do use session mapping parameters ?(in which transformation)
Explain etl mapping sheets?
explain the methodology of Data Warehousing?(Polaries)