Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2012 @ 22:14:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Can someone help me with the compression analysis?

I would need some info on how to determine the compression values. For example please find below some sample data. ?I am not sure if I can go by applying compression on top 3 ranks. Can someone guide me on this?

                                               Number of
     COLUMNNAME                       VALUE    records      RANK
     CPN_RWRD_QL_ACC_ISO_PROD_TP_CD      ?           2        ?
     CPN_RWRD_QL_ACC_ISO_PROD_TP_CD     20      51,234        1
     CPN_RWRD_QL_ACC_ISO_PROD_TP_CD     33       8,569        2
     CPN_RWRD_QL_ACC_ISO_PROD_TP_CD     10       1,519        3
     CPN_RWRD_QL_ACC_ISO_PROD_TP_CD     34         626        4

Thanks,

Vijay Mani

	<Prev	Next>		<<First	<Prev	Next>	Last>>