Dear experts,
I am finding a LOT of rows with NULL columns in the Sybase
tables I'm querying.
Say, there is a table, with 100 rows.

I heard from my collegue that in FME and some other ETL tools you will
creating scripts and scripts will create GUI and Mappings and it is
more effecient!
Does Informatica be able to do the same thing?

Let' look at the following scenario:
Database A with a Customer table, PK ID#.
Database B with a Customer table, PK ID#.
Both Database A & B are 2 different system and not related.

I am using SMO 2005 to assign alerts for error number 20574. My doubt
is whether we hav to assign job for the alerts that are created?? And
also will the alerts be generated when the error occurs and the
operators be notified thru email????

I need help tracking down some information regarding SQL Server 2000. I have
a VLDB that is at approixmately 85% space utilization on all of its drives.
Is there a recommended threshold where not enough free space is available for
SQL Server to maintain it's performance levels?

We're at the beginning of expanding our reporting system into a
datawarehouse. I'm conscious that column names need to be user friendly :
easy to understand and easy to find.
For example to help users find columns alphabetically I could prefix all

Hi all,
I'm new to datawarehousing. I've built a DW with two fact tables, each one
will be added with more than 5 to 10 millions rows each day. Do you think
that this volume is compatible with Analysis Services 2005 or do I have to

We have data migration process that transfers around 450 million records from
one DB to Another DB. There is a validation that takes place for the migrated
data that is time consuming (few days). The following validations takes place
on migrated data

Hi all !!
I would like to export a cube from a server to another. I don't need to
export any data, just the structure, fact table and some DTS packages. Any
idea ??

I have set formatting of a calculated member in a cube to 'percent'.
When I view the calculated member in an office 2003 pivot table, it
does not apply the formatting defined in the cube. Is there a way I can
get measures to display the format defined in the cube in a pivot

Hello everyone ::
we would like to ask you a question acording the usage of uniqueidentier as
key fields
we are planning to start designing an application in SQL server which should

Would like to learn how to create Data Warehouse. "AdventureWorks Data
Warehouse" sample is great sample. but it seems like that there is no
source/book to show that how to generate it from "AdventureWorks OLTP".
I would like to want to know the "PROCESS" or 'WHY ->>>> design ...

I used the deployment wizard in the analysis services 2005 to convert
the cube into XML script. Using the SQL Management Studio I opened it
as Analysis Server scripts and used the local host as the system in the
connections windows then loaded the XML script into the Queries window

Hi Dev guys,
Have hit a snag trying to use Usage Based Optimization (64bit AS 2K5
install, olapquerylog on SQL2K 32bit).  Going through the wizard I can
select the partition(s) I'm interested in applying the aggregation design to

I need suggestion in designing of the datamart .I am using SQL Server 2005
Analysis Services
The scenario is :
Judy, Carol are two customers who have registered for 2 products say VB