how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 14578 Views
- I also Faced
- E-Mail Answers
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 can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
what are the concerns of OLTP and DSS systems?
When do we go for the tools in the market?
What is a materialized view log?
when will use SQL override in a lookup transformation?
Explain the difference between etl tool and olap tools?
Explain what are the various etl tools in the market?
what do u do when DB time takes more?in sap bi
Compare ETL & Manual development?
what is granularity in Data ware House?
what is the main role of FI on business
How etl testing is different from database testing?
Explain etl mapping sheets?
how do u implement configuration management in Informatica?
What is full load & incremental or refresh load?
