September 11, 2013 \ Ananth TM \ 5 Comments Datastage Migration checklist Category Checkpoint SERVER INSTALLATION ACTIVTIES: Set up the data stage server and ODBC connections. SERVER INSTALLATION ACTIVTIES: Create login ids and passwords SERVER INSTALLATION ACTIVTIES: Set up the database configuration on the server like tnsnames.ora file in case of oracle. SERVER INSTALLATION ACTIVTIES: In case of a PX version (PX 8.0 now), extra steps need to be taken care like node config file etc CLIENT INSTALLATION ACTIVITY: Install the client components of Datastage on the individual machines and database client has to be set up as well. E.g. tnsnames.ora in case of Oracle. COMPONENTS MIGRATION ACTIVITIES: Get the inventory of the components to be migrated. (All active and functional jobs/processes & Static files on the existing server, if any) COMPONENTS MIGRATION ACTIVITIES: Prepare the mapping spreadsheet to be used in the transformer. It can be also derived from the existing processes. COMPONENTS MIGRATION ACTIVITIES: Convert the business logic from OWB format to Datastage transformation rules. COMPONENTS MIGRATION ACTIVITIES: Construct the Datastage jobs using the transformation rules. COMPONENTS MIGRATION ACTIVITIES: Error/exception handling needs to be taken care. COMPONENTS MIGRATION ACTIVITIES: If there is any in-built scheduling in OWB, then it may need to be shifted as well to Datastage level. Or another scheduling tool like ControlM may be put in place. COMPONENTS MIGRATION ACTIVITIES: If there is any user-defined procedure created in OWB for a specific purpose, then custom defined routines may have to be written in Datastage. COMPONENTS MIGRATION ACTIVITIES: Import the metadata from the database which makes the construction easier. Data modeling tool can be used here for metadata transfer.
sudheer1414 says September 19, 2013 at 7:35 am Thanks for sharing for this valuble information and it is very useful for data stage learners .123trainings also provide the bestDatastage Online Training you can see free demo Datastage Online Training Demo in Hyderabad India Reply
Ananth TM says September 20, 2013 at 1:30 am thank you. please let me know if there are other things which can be posted and would be useful. Reply
kumar says September 28, 2013 at 6:43 am this is very useful information and it is used for datastage learners.123trainings also provides data stage online training. Reply
hadoop online training says April 1, 2016 at 6:09 am I am extremely impressed with your writing skills and also with the layout on your blog thanks Reply
hadoop online training says April 26, 2016 at 8:16 am this is valuable information for learners.thanks Reply