Interested to Buy Any Domain ? << Click Here >> for more details...
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
Compare etl & elt?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Is apache nifi an etl tool?
what is pmrep command?
What are the different etl testing categories as per their function?
what are the reports developed in sap bw project and what is the requirement for developing it?
Compare ETL & Manual development?
what is the use of structures?how many nodes can u create in a structure?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
explain the methodology of Data Warehousing?(Polaries)
What are dimensions?
How many steps etl contains?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain do we need an etl tool?
