Answer Posted / ravikumar
Hi,
You can Say LookUp is a Left Outer join.Your Source Table is
Left side table and Lookup table is right table.
Now you are trying to get total source records and
matching records from lookup table(right table).
Hope this helpls....
ravikumar.pasupula@outlook.com
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is etl process?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
How to fine tune mappings?
Explain what are the various etl tools in the market?
What are the types of Data Warehouse applications?
What is the difference between round-robin partitioning and hash partitioning?
What is a staging area? What is the purpose of a staging area?
what are the concerns of OLTP and DSS systems?
Compare ETL & Manual development?
what are the concerns of OLTP and DSS systems?
what is the use of structures?how many nodes can u create in a structure?
What is tracing level and what are the types?
What are the different etl testing categories as per their function?
What is data modeling and data mining?
What do you understand by the term ‘transformation’?