Longitude field
I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don’t want to rely on the user [...]
Answer Question
| September 10, 2008 1:42 PM
Data management and storage, GIS software
I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don’t want to rely on the user [...]
Answer Question
| September 10, 2008 1:42 PM
Data management and storage, GIS software
Move data in SSIS via store procedure
How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?
Answer Question
| September 5, 2008 10:14 PM
Import external data, SSIS, Stored Procedures
How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?
Answer Question
| September 5, 2008 10:14 PM
Import external data, SSIS, Stored Procedures
Sum Values Of A Particular Column In A Tilde Delimited File on Solaris
Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks
Answer Question
| September 6, 2008 2:01 PM
Database, DataManagement, Development, Unix
Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks
Answer Question
| September 6, 2008 2:01 PM
Database, DataManagement, Development, Unix
Do 10Gbit iSCSI and 8Gbit FC change how you think about your strategy for managing your data in the future?
Do 10Gbit iSCSI and 8Gbit FC change how you think about this and your strategy for managing your data in the future?
Answer Question
| November 6, 2008 5:31 PM
Data management, Dell Storage, Fibre channel, iSCSI, Storage strategy
Do 10Gbit iSCSI and 8Gbit FC change how you think about this and your strategy for managing your data in the future?
Answer Question
| November 6, 2008 5:31 PM
Data management, Dell Storage, Fibre channel, iSCSI, Storage strategy
Community Update: New Member Contest Win a XBox 360 this month for your participation.
After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on [...]
Answer Question
| September 8, 2008 1:13 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, Virtualization and the hypervisor, VoIP
After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on [...]
Answer Question
| September 8, 2008 1:13 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, Virtualization and the hypervisor, VoIP
Move media to one location
Currently I have (2) locations for the Data Center defined in BRMS and they are *HOME and DATACENTER. Currently, Operations has to verify expired media when it moves from DATACENTER to *HOME. I think this is a waste of time so I want to get rid of the DATACENTER location. Design a plan to move [...]
Answer Question
| August 28, 2008 5:39 PM
BRMS, Data migration
Currently I have (2) locations for the Data Center defined in BRMS and they are *HOME and DATACENTER. Currently, Operations has to verify expired media when it moves from DATACENTER to *HOME. I think this is a waste of time so I want to get rid of the DATACENTER location. Design a plan to move [...]
Answer Question
| August 28, 2008 5:39 PM
BRMS, Data migration
SPSS Data in Data Editor BUT Unable to Analyze
I have successfully downloaded the 1998 RAND HRS fat file data and the data is present in Data Editor of SPSS. However, I am unable to analyze the data – the prompt I receive is that the system is not responding and it seems like the computer is locked. I also observe an asterick preceeding [...]
Answer Question
| August 27, 2008 12:52 PM
SPSS, SPSS Data Editor
I have successfully downloaded the 1998 RAND HRS fat file data and the data is present in Data Editor of SPSS. However, I am unable to analyze the data – the prompt I receive is that the system is not responding and it seems like the computer is locked. I also observe an asterick preceeding [...]
Answer Question
| August 27, 2008 12:52 PM
SPSS, SPSS Data Editor
data input
what method of data input would be best for printed questionnaires?
Answer Question
| August 15, 2008 8:04 PM
Data analysis
what method of data input would be best for printed questionnaires?
Answer Question
| August 15, 2008 8:04 PM
Data analysis
jasper ad-hoc report takes more time
problem is that jasper ad-hoc reports take more time how to resduse it ,some time it take less time but some time it takes more than expected what is the solution of that . If may be any problem please tell me as soon as possible.
Answer Question
| August 7, 2008 10:23 AM
Business intelligence software, Data mining/analysis, JasperServer
problem is that jasper ad-hoc reports take more time how to resduse it ,some time it take less time but some time it takes more than expected what is the solution of that . If may be any problem please tell me as soon as possible.
Answer Question
| August 7, 2008 10:23 AM
Business intelligence software, Data mining/analysis, JasperServer
from 1 to 1440 in SPSS
First: How do i create a time serie in spss from 1 to 1440 (1440 rows)? Second: if this is to be done in a time format (00:01, 00:02, 00:03……..23:59) how can I do that? THX
Answer Question
| April 13, 2012 7:34 PM
SPSS, time series
First: How do i create a time serie in spss from 1 to 1440 (1440 rows)? Second: if this is to be done in a time format (00:01, 00:02, 00:03……..23:59) how can I do that? THX
Answer Question
| April 13, 2012 7:34 PM
SPSS, time series
How to generate MDX query from cube?
hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.
Answer Question
| August 4, 2008 7:16 PM
MDX Query, SSAS
hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.
Answer Question
| August 4, 2008 7:16 PM
MDX Query, SSAS
Explaining features in SQL Server 2005
I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?
Answer Question
| July 28, 2008 3:42 PM
Data analysis, Data integration, SQL Server 2005
I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?
Answer Question
| July 28, 2008 3:42 PM
Data analysis, Data integration, SQL Server 2005
Spss data analysis
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 1:07 AM
Business Intelligence, Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 1:07 AM
Business Intelligence, Data analysis, SPSS
Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 5:00 PM
Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 5:00 PM
Data analysis, SPSS
Informatica MAP creation to RESTART
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.
Answer Question
| July 24, 2008 11:41 AM
Data mining/analysis, Database programming, Informatica
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.
Answer Question
| July 24, 2008 11:41 AM
Data mining/analysis, Database programming, Informatica
How do I receive java-agent-backend-data in UI
I need help! a doc is open in UI. After pressing a button, the doc ist opened in a dialogbox for extra input. dlg_res = workspace.DialogBox( “DMS_Indizierung”, True, True, False , False , True, False, _ “In eAK überleiten …”, ,True, False, True ) In Queryclose there are more checks and an agent is started. [...]
Answer Question
| July 22, 2008 6:22 AM
Agents, Data analysis, Java, UI, Web services
I need help! a doc is open in UI. After pressing a button, the doc ist opened in a dialogbox for extra input. dlg_res = workspace.DialogBox( “DMS_Indizierung”, True, True, False , False , True, False, _ “In eAK überleiten …”, ,True, False, True ) In Queryclose there are more checks and an agent is started. [...]
Answer Question
| July 22, 2008 6:22 AM
Agents, Data analysis, Java, UI, Web services
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
Answer Question
| July 21, 2008 6:06 AM
SQL Mail, SQL Server 2005, SQL Server Integration Services, SSIS
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
Answer Question
| July 21, 2008 6:06 AM
SQL Mail, SQL Server 2005, SQL Server Integration Services, SSIS
Best practice of maintaining master data
What are best practices in maintaining master data? Who should own the responsibility of owning this data?
Answer Question
| July 15, 2008 8:09 PM
Data management best practices, Data management tools
What are best practices in maintaining master data? Who should own the responsibility of owning this data?
Answer Question
| July 15, 2008 8:09 PM
Data management best practices, Data management tools
HUGE hard disks problem, PLEASE! help.
HUGE hard disks problem, PLEASE! help. (Apologies for the lengthy message. My technical expertise is nil and I don’t know what information is needed, so I prefer to include every possible detail. Neither is my English very good, but I hope to be able to explain the situation clearly) My computer is an old modified [...]
Answer Question
| November 2, 2011 4:17 PM
Backup & recovery, Data migration, Disk drives, Hard drive repair, Migrations and upgrades
HUGE hard disks problem, PLEASE! help. (Apologies for the lengthy message. My technical expertise is nil and I don’t know what information is needed, so I prefer to include every possible detail. Neither is my English very good, but I hope to be able to explain the situation clearly) My computer is an old modified [...]
Answer Question
| November 2, 2011 4:17 PM
Backup & recovery, Data migration, Disk drives, Hard drive repair, Migrations and upgrades
Does anyone have an MS Project file for a DW implementation they’d be willing to share?
Greetings all, As my orgaization begins the planning phase of a data warehouse implementation, I’d imagine it would be a true benefit to have a roadmap of an actual DW implementation in order to make certain all areas are addressed. Does anyone have a complete DW in MS Project form? Many thanks! Da Celt
Answer Question
| June 23, 2012 12:56 PM
Business Information Warehouse, Data management and storage, Data warehouses, Data warehousing applications, Database engineering, DataManagement
Greetings all, As my orgaization begins the planning phase of a data warehouse implementation, I’d imagine it would be a true benefit to have a roadmap of an actual DW implementation in order to make certain all areas are addressed. Does anyone have a complete DW in MS Project form? Many thanks! Da Celt
Answer Question
| June 23, 2012 12:56 PM
Business Information Warehouse, Data management and storage, Data warehouses, Data warehousing applications, Database engineering, DataManagement
