Software Applications Programming Errors and solutions.

Issue : This error come  before when migrate data from oracle to SQL server using SSIS ? Error Column "Col1" cannot convert between unicode and non-unicode string data types Solution: The column is coming back as unicode and then either being loaded into a non-unicode (varchar) column in the table, or possibly set to output as non-unicode in the oracle source (or non-unicode to unicode). Try putting a data conversion component in the data flow between the source and destination, and set data_1 column to match the type and width of the target table/column.

Interview Questions and Answers for SQL Server 1. What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependence's among these tables are expressed by data values rather than by pointers. This allows a high degree of data independence. An RDBMS has the capability to recombine the data items from different files, providing powerful tools for data usage. 2. What are the properties of the Relational tables? Relational tables have six properties: Values are atomic. Column values are of the same kind. Each row is unique. The sequence of columns is insignificant. The sequence of rows is insignificant. Each column must have a unique name. 3. What is Normalization? Database normalization is a d...