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
Answer / kasi reddy
using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table
Is This Answer Correct ? | 3 Yes | 1 No |
what is different between sequential batch and concurrent batch and which is recommended and why?
Can we create Hierarchies in generic datasources?
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 is granularity? Please explain with example
what are Lookup caches options? Including persistent caches.
What is a staging area? What is the purpose of a staging area?
Eliminating of duplicate records without using dynamic lookups
how do u set partition points in the mapping?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Define slowly changing dimensions (SCD)?
What is a materialized view log?
what is session partitioning?