how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / k bhavani durga
this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.
it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is the difference between Data Warehousing and Data Mining?
how many steps are there in etl process?
Is apache nifi an etl tool?
State the differences between shortcut and reusable transformation
dimension object created in oracle can be imported in designer?how?
What are the various tools used in etl?
if i have a query as flat file how can we load data to target table
What is partitioning? Explain different types of partitioning?
What is cube grouping?
When do we analyze the tables? How do we do it?
What are the key benefits of ETL Testing?
What is lookup table in etl testing?