Technology Questions

A junction record is a member record type that allows for many-to-many relationship between its two owner records.

Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged.

Data cleaning is performed by reading all records in a set and verifying their accuracy. Typos and spelling errors are rectified. Mislabeled data if available is labeled and filed. Incomplete or missing entries are completed. Unrecoverable records are purged, for not to take space and inefficient operations.

IDMS uses record locks to prevent another run-unit from updating the same record.

$result = mysql_query($sql, $db_link);
$num_rows = mysql_num_rows($result);
echo "$num_rows rows found";

Permissions in PHP are very similar to UNIX. Each file has three types of permissions – Read, write and execute. Permissions can be changed using the change mode or CHMOD command. CHMOD is followed by 3 digit number specifying the permission type. CHMOD 777 is for Read, Write and execute.

Unnecessary permissions can be stripped off using UNMASK command.

Unmask (777);

RequiredFieldValidator is used to validate the controls if they contain data

To open a page in a new window, you have to use client script using onclick="window.open()" attribute of HTML control.