RE: What are the difficulties faced in using DataStage...
1. I feel the most difficult part is understanding the "Datastage director job log error messages'. It doesn't give u in proper readable message. 2.We dont have many date functions available like in Informatica or traditional Relational databases.
3. Datastage is like unique product interms of functions ex: Most of the database or ETL tools use for converting from lower case to upper case : UPPER. The datastage uses "UCASE". Datastage is peculiar when we compare to other ETL tools.
Otherthan that i dont see any issues with Datastage.
RE: What are the difficulties faced in using DataStage...
* The issue that i faced with datastage is that it was very difficult to find the errors from the error code since the error table did not specify the reason for the error. And as a fresher i did not know what the error codes satnd for :)
* Another issue is that the help in the datastage was not of much use since it was not specific and was more general.
* I donot know about other tools since this is the only tool that i have used until now. But it was simple to use so liked using it inspite of above issues.
