How do I confirm all the data moved from Source to target for different tables
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN —————– kccrosser I commonly check two tables using either EXCEPT [...]
View Answer
| November 25, 2009 11:26 PM
Data migration, SQL, SQL migration
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN —————– kccrosser I commonly check two tables using either EXCEPT [...]
View Answer
| November 25, 2009 11:26 PM
Data migration, SQL, SQL migration
The IT Blog Top 10: Oct. 29, 2009
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov…. just wondering!
View Answer
| November 25, 2009 5:03 AM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov…. just wondering!
View Answer
| November 25, 2009 5:03 AM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Is there dashboard/data mining software which is geared for a small business?
This might help if you are a developer. It easily graphs data and supports drill down. It’s totally free and totally customizable if you have Excel. <a href=”http://itknowledgeexchange.techtarget.com/beyond-excel/”>Beyond Excel</a>
View Answer
| November 19, 2009 2:43 AM
Dashboard software, Data Mining, Data mining/analysis
This might help if you are a developer. It easily graphs data and supports drill down. It’s totally free and totally customizable if you have Excel. <a href=”http://itknowledgeexchange.techtarget.com/beyond-excel/”>Beyond Excel</a>
View Answer
| November 19, 2009 2:43 AM
Dashboard software, Data Mining, Data mining/analysis
“map drive” IFS
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]
View Answer
| November 14, 2009 12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]
View Answer
| November 14, 2009 12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support
Passing data between two SQL Server databases
I’ve had to do stuff like this in the past. In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to [...]
View Answer
| November 13, 2009 12:32 AM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
I’ve had to do stuff like this in the past. In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to [...]
View Answer
| November 13, 2009 12:32 AM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
How to combine 2 linked Excel tables in access 2003 with same field names, using query?
For the linked table approach. Make a Union query in Access. Select EmployeeID, CustomerID, Address From LinkedTable1 Union All Select EmployeeID, CustomerID, Address From LinkedTable2 This should do what you are asking for. The All part of the union brings in records that might be the same in both tables. If it could happen that [...]
View Answer
| November 6, 2009 8:59 PM
Access 2003, Data management, Microsoft Access query
For the linked table approach. Make a Union query in Access. Select EmployeeID, CustomerID, Address From LinkedTable1 Union All Select EmployeeID, CustomerID, Address From LinkedTable2 This should do what you are asking for. The All part of the union brings in records that might be the same in both tables. If it could happen that [...]
View Answer
| November 6, 2009 8:59 PM
Access 2003, Data management, Microsoft Access query
STRQMQRY problem
Do you want to remove the prompt because it’s always the same company? It looks like you want company 10 from your DCL statements… you can change the setvar to use the &COMP# rather than the &OSCOMP variable. ===================================================== You have &OSCOMP declared as a *CHAR — is oscomp in the table a CHAR or [...]
View Answer
| October 31, 2009 11:26 AM
AS/400, Certifications, Data analysis, Development, Lifecycle development, Software Quality Assurance, Software testing
Do you want to remove the prompt because it’s always the same company? It looks like you want company 10 from your DCL statements… you can change the setvar to use the &COMP# rather than the &OSCOMP variable. ===================================================== You have &OSCOMP declared as a *CHAR — is oscomp in the table a CHAR or [...]
View Answer
| October 31, 2009 11:26 AM
AS/400, Certifications, Data analysis, Development, Lifecycle development, Software Quality Assurance, Software testing
SPSS Binary Regression
Hi Harry19192929, In my experience with SPSS, that is how we would always enter M and F variables. There might even be a special “data type” option that allows you to keep the variables “M” and “F” (“gender” or something similar). Good luck! Jenny Community Manager
View Answer
| October 26, 2009 2:01 PM
SPSS
Hi Harry19192929, In my experience with SPSS, that is how we would always enter M and F variables. There might even be a special “data type” option that allows you to keep the variables “M” and “F” (“gender” or something similar). Good luck! Jenny Community Manager
View Answer
| October 26, 2009 2:01 PM
SPSS
The most-watched IT questions this week: Oct. 20, 2009
I haven’t looked at any of those !!
View Answer
| October 21, 2009 1:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
I haven’t looked at any of those !!
View Answer
| October 21, 2009 1:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
OPNQRYF vs Logical files
Hi The quick and simple file is that the logical file will already have the index built and therefore has a speed advantage over OPNQRYF which has to build the index before it can be used. The down side to the LF is that it takes up space on the disk. The primary advantage of [...]
View Answer
| October 21, 2009 5:55 AM
Data analysis, Programming Languages, RPG
Hi The quick and simple file is that the logical file will already have the index built and therefore has a speed advantage over OPNQRYF which has to build the index before it can be used. The down side to the LF is that it takes up space on the disk. The primary advantage of [...]
View Answer
| October 21, 2009 5:55 AM
Data analysis, Programming Languages, RPG
Updating a View
A true “view” automatically updates when the underlying data is updated. Also, in SQL Server an “indexed view” also refreshes automatically. If this is an Oracle materialized view, then the view definition can specify the refresh method for automatic refreshing (periodically on a timed basis or whenever an underlying table is changed). You would need [...]
View Answer
| October 9, 2009 3:23 PM
Data management and storage, Database, SQL, Updates, Views
A true “view” automatically updates when the underlying data is updated. Also, in SQL Server an “indexed view” also refreshes automatically. If this is an Oracle materialized view, then the view definition can specify the refresh method for automatic refreshing (periodically on a timed basis or whenever an underlying table is changed). You would need [...]
View Answer
| October 9, 2009 3:23 PM
Data management and storage, Database, SQL, Updates, Views
SSIS cache
Maybe there are more records than will fit in cache, so using full cache you are not comparing to the complete file. Also, if any records are changed during runtime, the changed records will not be in cache.
View Answer
| September 16, 2009 12:02 AM
SSIS, SSIS 9.00.3042.00, SSIS Lookup Cache
Maybe there are more records than will fit in cache, so using full cache you are not comparing to the complete file. Also, if any records are changed during runtime, the changed records will not be in cache.
View Answer
| September 16, 2009 12:02 AM
SSIS, SSIS 9.00.3042.00, SSIS Lookup Cache
Do your users have the right analytical tools to make informed decisions?
Not at the moment, however… My company is in the process if investigation BI tools to meet this requirement. We have found that in the eyes of a user, it is the right tool if they can get the data out easily and quickly, with a simple UI. In the eyes of the super-user / [...]
View Answer
| September 10, 2009 3:54 PM
Analytical tools, Data Analytics, SPSS
Not at the moment, however… My company is in the process if investigation BI tools to meet this requirement. We have found that in the eyes of a user, it is the right tool if they can get the data out easily and quickly, with a simple UI. In the eyes of the super-user / [...]
View Answer
| September 10, 2009 3:54 PM
Analytical tools, Data Analytics, SPSS
Are your analytical assets and processes visible, automated and secure?
For us security is always the biggest issue with so many users accessing the data in different locations it can be challenging at times. We try to secure as much as we know that needs to be secured. But its sometimes nebulous as to what needs to be secured, and where is that currently stored.
View Answer
| August 30, 2009 1:25 PM
Analytical tools, Analytics, CRM, CRM analytics, SPSS
For us security is always the biggest issue with so many users accessing the data in different locations it can be challenging at times. We try to secure as much as we know that needs to be secured. But its sometimes nebulous as to what needs to be secured, and where is that currently stored.
View Answer
| August 30, 2009 1:25 PM
Analytical tools, Analytics, CRM, CRM analytics, SPSS
How can I estimate data migration costs?
I havent seen one. If it helps, I am in the process of paying over 60k for about 100tb of data connected to 24 server. This is only for the storage migration. No desktops, or routers.
View Answer
| August 27, 2009 6:18 PM
Data migration, Data Migration Costs
I havent seen one. If it helps, I am in the process of paying over 60k for about 100tb of data connected to 24 server. This is only for the storage migration. No desktops, or routers.
View Answer
| August 27, 2009 6:18 PM
Data migration, Data Migration Costs
Build a Data warehouse end to end
To prepare proposal you need to have a good understanding of user need in terms of the following 1. What they want 2. How they want 3. When they want 4. Who want it 5. Why want it Answers from all the above questions will be derived from Interviews, Tenders document, Discussion of team mebers [...]
View Answer
| August 25, 2009 6:26 AM
Data Warehouse Planning, Data warehouses, Data warehousing
To prepare proposal you need to have a good understanding of user need in terms of the following 1. What they want 2. How they want 3. When they want 4. Who want it 5. Why want it Answers from all the above questions will be derived from Interviews, Tenders document, Discussion of team mebers [...]
View Answer
| August 25, 2009 6:26 AM
Data Warehouse Planning, Data warehouses, Data warehousing
3 bit parity
This should help: <a href=”http://graphics.stanford.edu/~seander/bithacks.html”> link.</a>
View Answer
| November 9, 2012 9:46 PM
Data management and storage, parity, RAID
This should help: <a href=”http://graphics.stanford.edu/~seander/bithacks.html”> link.</a>
View Answer
| November 9, 2012 9:46 PM
Data management and storage, parity, RAID
SQL Express used for SSIS?
According to <a href=”http://msdn.microsoft.com/en-us/library/cc645993.aspx”>this Microsoft document</a>, with the express editions you get only the Import and Export Wizard, and the basic Integration Services features required by the wizard. Al other SSIS features are not included, so you would need standard or enterprise edition.
View Answer
| August 17, 2009 2:53 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS
According to <a href=”http://msdn.microsoft.com/en-us/library/cc645993.aspx”>this Microsoft document</a>, with the express editions you get only the Import and Export Wizard, and the basic Integration Services features required by the wizard. Al other SSIS features are not included, so you would need standard or enterprise edition.
View Answer
| August 17, 2009 2:53 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS
Data Migration Project Life Cycle
Two questions in one here: Project lifecycle and data migration; data migration is moving data form one system into another system, but more on this later below. Project Lifecycle is a process of steps taking a set of interrelated tasks form one point to another. A project lifecycle covers (but not limited to) the following: [...]
View Answer
| August 10, 2009 8:48 PM
Data migration, Data Migration Testing, Life cycle management, QA, Testing software
Two questions in one here: Project lifecycle and data migration; data migration is moving data form one system into another system, but more on this later below. Project Lifecycle is a process of steps taking a set of interrelated tasks form one point to another. A project lifecycle covers (but not limited to) the following: [...]
View Answer
| August 10, 2009 8:48 PM
Data migration, Data Migration Testing, Life cycle management, QA, Testing software
