how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / 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 |
Post New Answer View All Answers
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what is data modeling?
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?
Difference between flat files and relational sources?
what is Forward,Reverse and Re_engineering?
what is the use of server?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are various etl tools in the market?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is meant by incremental load?
What are snapshots?
How etl testing is different from database testing?
What is a staging area? What is the purpose of a staging area?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Explain the key challenges that you face while performing etl testing.