Why is Hashed File data changing randomly
Posted: Tue May 19, 2009 2:38 am
Hi friends,
Iam facing an issue in the hash file for one particular column. The column length is 1000. As the data is too big, each time when retrieved from the table and loaded to the hashfile, the data in the column is rearranged randomly.
Say my data is Energy systems / technology, Industrial wastewater treatment. ....etc.,
It stores as Industrial wastewater , Energy systems / technology, .etc., in the hash file .
This creates an issue while am trying to do SCD process, as each time am running the scd job it is going to the update link even if the source data remains unchanged.
So is there any way to keep the data unchanged,can any one help me out?
Thanks in advance
Iam facing an issue in the hash file for one particular column. The column length is 1000. As the data is too big, each time when retrieved from the table and loaded to the hashfile, the data in the column is rearranged randomly.
Say my data is Energy systems / technology, Industrial wastewater treatment. ....etc.,
It stores as Industrial wastewater , Energy systems / technology, .etc., in the hash file .
This creates an issue while am trying to do SCD process, as each time am running the scd job it is going to the update link even if the source data remains unchanged.
So is there any way to keep the data unchanged,can any one help me out?
Thanks in advance