topic Re: Pooled Data & Cluster Data in Application Development and Automation Discussions

Pooled Data & Cluster Data

Former Member — Fri, 06 Oct 2006 08:53:31 GMT

hello

Can any one give mee a Practical example of both for Pooled data and Cluster Data

Awards for Sure

Former Member — Fri, 06 Oct 2006 10:00:07 GMT

Have a look at below link.

The cdhdr and cdpos tables have four primary key fields in common and are always accessed together and are stored in the table cluster cdcls.

Best Regards,

Vibha Deshmukh

*Plz mark useful answers

Former Member — Fri, 06 Oct 2006 10:00:41 GMT

Check this link:

Regards,

Prakash.

anversha_s — Fri, 06 Oct 2006 10:03:03 GMT

hi,

Pooled Table:

Pooled tables are logical tables that must be assigned to a table pool when they are defined.

Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool.

The data of these pooled tables are then sorted in a common table in the database.

(<b>e.g. screen sequences, program parameters or temporary data..</b> )

Cluster Table:

Cluster tables are logical tables that must be assigned to a table cluster when they are defined.

Cluster tables can be used to strore control data.

They can also be used to store temporary data or texts, such as documentation.

<b>eg : chk this table PCL1 - HR related data</b>

rgds

anver

Message was edited by: Anversha s

Former Member — Fri, 06 Oct 2006 10:07:33 GMT

thankx Anversha s

but i want to known the practical example of the both they have asked me the same question in Interview

Former Member — Fri, 06 Oct 2006 10:19:01 GMT

TRMAC is pooled table.

Best Regards,

Vibha Deshmukh

*Plz mark useful answers