Kill me now. My first impression of DataStage was: 'Eww'. So all the beautiful SQL queries are hidden inside horrible GUI 'stages', in text fields that become single line textboxes when you double click (You know, like when you are selecting a word). So all day I'm turning fields into single line textboxes on accident... because that's useful.
As solutions grow, you get to scour through dozens - or hundreds - of jobs, filled with who knows how many stages. What if you need to find something? Hehehe. Welcome to DataStage.
What if you have a job that pulls data from a database and runs that data through a dozen stages (You know to do joins and stuff, cuz SQL is haard) and outputs it to a dataset or something. Uhoh, you forgot you needed the LastName column. Hehehe. Get your mouse finger ready. You get to double click every single stage, click on inputs and outputs and mapping tabs. Type out the column name, specify its datatype etc, drag stuff around, go back and forth hooking up your new column to pass it down the chain.
Time to debug? Hehehe. Get Toad or SSMS fired up, because you get to go back and forth from DataStage to the actual database. Records are getting dropped somewhere? Hehe. Good luck with that. Stage X SHOULDN'T be dropping my record. But it is. Have fun.
Maybe DS isn't so bad and I'm just a noob - but my team supports apps built in it - and I have two days to make it happen.
DataStage. Pffffff.
