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)
What do you understand by active and passive transformations?
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
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are the three tiers in etl?
how do u implement configuration management in Informatica?
What are cubes and olap cubes?
what is dynamic insert?
how do u set partition points in the mapping?
how would u estimate the size of Aggregator transform data and index cache?
What are the key benefits of ETL Testing?
what is session partitioning?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Difference between flat files and relational sources?
What are dimensions?