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
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
Explain do we need an etl tool? When do we go for the tools in the market?
Explain the difference between etl tool and olap tools?
what is an ETL or ETT? And what are the different types?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What are the different Lookup methods used in Informatica?
what is the meant by Normalization and de-normalization?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What are cubes and olap cubes?
Give the benefits of data integration suite?
what are the reporting tools and difference between them?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what are the production issues in datastage?
Do we need an ETL tool? When do we go for the tools in the market?
what do u do when DB time takes more?in sap bi
