Siddu Patil

• Oct 7th, 2005

 

1)If the number of lookups are more?

2)what will happen, while loading the data  due to some regions job aborts?

hanug

 Profile Answers by hanug 

• May 6th, 2007

 

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.

Hanu.

Rekha

• Jul 21st, 2007

 

* 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.