limitations of datastage

kamesh · Post by **kamesh** » Tue Jun 14, 2005 4:10 am

Can anyone tell me are there any limitations in datastage tool
Thanks
kamesh

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 14, 2005 4:20 am

There are limitations in any software or tool. Any limitation can be counteracted by alternative means such as knowledge in other software linked to DataStage.

Can you provide more information as to what you are looking for and why.

kamesh · Post by **kamesh** » Tue Jun 14, 2005 4:41 am

limitations on handling different data sources,handling huge data, speed etc

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 14, 2005 4:59 am

There are many combinations and options. The solution will be specific to each customer.

In this case, are you asking for professional services?

roy · Post by **roy** » Tue Jun 14, 2005 6:01 am

Hi,
In general there are no logical limitations what so ever.
since you can build and incorporate missing functionality potentially there are no connectivity limits (what you lack today can be provided tomorrow)
where processing is concerned you have (AFAIK) a liniar growth comitment in processing vrs resources provided.

Anything you can get to be important enough to the product provider they will make the effort to acomodate your needs.

more to the point if you'll ask a more specific question you might get an up to date availability statement regarding your specific situation.

Bare im mind that if the organization prevents direct access to a production system to extract data and you must wait till they unload the data to flat files, maybe even forcing you to use a 3rd party ODBC to read the files, you might get bad performance in any tool out there, regardless of what tool it is.

IHTH,

ray.wurlod · Post by **ray.wurlod** » Tue Jun 14, 2005 3:09 pm

Of course there are limits, but you'll never hit most of them. For example, a DataSet or FileSet can contain a maximum of 10000 files each not larger than 2GB per processing node. You can do the math.

The main limitation seems to be the unwillingness of some to spend a couple of thousand dollars getting training in the best way to use software on which they've spent a six figure sum.