I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE
- 1 Answers
- 5290 Views
- Wipro, I also Faced
- E-Mail Answers
code should be like this:
Check whether the pk is present, if present, its a duplicate record.
then check for the null values
then check for invalid date columns
iif(not isnull(pk),error_code_dup_rec,
iif(isnull(col1)
or (is null(col2),null_value_
present,
or is null(date),invalid_date,valid_record))
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain bus schema?
Explain what are the possible data marts in retail sales?
Code the tables statement for a single-level (most common) frequency?
What is difference between a connected look up and unconnected look up?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is Grain & Granularity in Data Warehouse.
How to define a cube??
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Can you brief about the Data warehouse project you worked on?
How do you create surrogate key using ab initio?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Teradata 
