if source contain 10records how you identify header and footer
Answer Posted / guest
If a source file will have header and footer, then header record will start with 0, trailer record will start with 9 and the detailed record will start with 1.
so the first record starts with zero, next 8 records with 1 and the last record with a 9.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is recovering sessions?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are the fundamental elements of the data warehouse?
What is a relationship?
What are different deliverables according to phases?
What is the data type of the surrogate key?
How many types of facts and what are they?
Explain the main differences between star and snowflake schema?
Explain what are non-additive facts?
How can you clear the cache?
What is the difference between filter and lookup transformation?
What are the various methods of getting incremental records or delta records from the source systems?
What are modeling tools available in the market?
What is aggregate fact table?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?