What is the difference between internal tables and extract datasets?

• The lines of an internal table always have the similar structure. By using extract datasets, you can handle groups of data with dissimilar structure and get statistical figures from the grouped data.
• You have to describe the structure of the internal table at the starting. You need not describe the structure of the extract dataset.
• In contrast to internal tables, the system partly compresses precise datasets when storing them. This decreases the storage space required.
• Internal tables need special work area for interface while extract datasets do not require a special work area for interface.

 

Posted Date: 5/11/2013 3:59:01 AM | Location : United States

Ask an Expert

Related Discussions:- Difference between internal tables and extra datasets, Assignment Help, Ask Question on Difference between internal tables and extra datasets, Get Answer, Expert's Help, Difference between internal tables and extra datasets Discussions

Write discussion on Difference between internal tables and extra datasets
Your posts are moderated

Write your message here..

Related Questions

What is asterisk in sql, What is Asterisk in SQL? Asterisk (*): In SQL,... What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Define data model, Define data model? A data model is a collection of c... Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.

What is a b+-tree index, What is a B+-Tree index? A B+-Tree index takes... What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

What do you mean by an execution plan, What do you mean by an execution pla... What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

Vertical fragmentation, Vertical Fragmentation- Vertical fragmentation grou... Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

What is a homogeneous distributed database, What is a homogeneous distribut... What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Which two files are used during operation of the dbms, Which two files are ... Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Differentiate between pl/sql functions and procedures, Oracle & Distributed... Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

Frequecy count, how to calculate frequency count of algorithm how to calculate frequency count of algorithm

Database management system, Distributed Database Management System Distributed Database Management System