if u can't find what you are looking for in lookup table,
how do you handle?
Answer Posted / raj.arjunan
This Depend on the situation,
To Check the value is there or not there two ways
1. Use notfound function (if possible)
2. Check the Key value from lkp as NULL
Than based on the requirement generate error/Put default
value
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
explain the methodology of Data Warehousing?(Polaries)
Give the benefits of data integration suite?
what are Lookup caches options? Including persistent caches.
how would u estimate the size of Aggregator transform data and index cache?
what is the difference steps for data modeling?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What are the key benefits of ETL Testing?
What is full load & incremental or refresh load?
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain do we need an etl tool?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
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 materialized views & where do we use them?