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


Please Help Members By Posting Answers For Below Questions

How to reduce warnings?

617


for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1753


What is hybrid slowly changing dimension?

716


Explain what is full load & incremental or refresh load?

609


Explain what is real time data-warehousing?

689






Code the tables statement to produce a multi-level frequency?

626


What are the different types of datawarehosuing?

631


What are data modeling and data mining? Where it will be used?

618


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

581


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

603


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?

615


What are the differences between star and snowflake schema?

581


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?

625


What is the purpose of cluster analysis in data warehousing?

653


What are aggregate transformation?

679