if source contain 10records how you identify header and footer
Answer Posted / ankit kansal
The basic rules regarding any file states that a file first line must be a header and last row must be a footer for a particular file.
So while reading your data you can provide validation and can handle all the situations differently as per your business needs.
http://deepinopensource.blogspot.in
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to reduce warnings?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is hybrid slowly changing dimension?
Explain what is full load & incremental or refresh load?
Explain what is real time data-warehousing?
Code the tables statement to produce a multi-level frequency?
What are the different types of datawarehosuing?
What are data modeling and data mining? Where it will be used?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are the differences between star and snowflake schema?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is the purpose of cluster analysis in data warehousing?
What are aggregate transformation?