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
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is staging area referring to?
Explain the key challenges that you face while performing etl testing.
What is a materialized view log?
What are the key benefits of ETL Testing?
How many steps etl contains?
What are snapshots?
what is the meant by Normalization and de-normalization?
What are the various tools used in etl?
what are the data modeling tools you have used?(polaris)
Explain the difference between etl tool and olap tools?
What are materialized views & where do we use them?
What is data cleaning?
how many maximum session supports to multiload in teradata ??