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
What are snapshots?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
Explain about etl data integration software?
Explain what is etl process? How many steps etl contains explain with example?
how to load the data to fact table?
what are the concerns of OLTP and DSS systems?
What is cube grouping?
Define Dynamic push down optmization?
what is dynamic insert?
What is etl tool in hadoop?
What is initial load and what is full load?
State the differences between shortcut and reusable transformation
Explain about hash partitioning?
What is data cleaning?
what is the use of server manager?