what ETL develoer do in a project from scratch

cetzhbo · Post by **cetzhbo** » Sun May 18, 2008 8:13 am

Hello Gurus,

will you please tell me what ETL develoer do in a project from scratch ?

thanks very mcuh!

chulett · Post by **chulett** » Sun May 18, 2008 8:20 am

Sorry, but you are going to have to rephrase that, perhaps narrow it down a bit. I (for one) have no idea what you are asking.

cetzhbo · Post by **cetzhbo** » Sun May 18, 2008 8:52 am

sure, I am DW QA right now, but I want to be a ETL developer. so will you please give me a detail description about the whole process for ETL developing using DATASTAGE . or please recomment where can I get that information.

chulett · Post by **chulett** » Sun May 18, 2008 2:48 pm

"will you please give me a detail description about the whole process for ETL developing using DATASTAGE"

That's a pretty tall order and not exactly what we are here for. Seems like your best option would be to get your hands on the "Developer's Guides" pdf manuals that ship with the product. There's one for Server and one for Parallel. All of them can be downloaded from IBM's site, from what I recall, but not all of them are free.

ray.wurlod · Post by **ray.wurlod** » Sun May 18, 2008 3:20 pm

Enrol in a DataStage Essentials training class. DataStage is no longer a tool that can be used "out of the box" by a novice. At least not effectively.

DSRajesh · Post by **DSRajesh** » Mon May 19, 2008 7:17 am

datastage job design,job review,testing etc....

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 5:20 pm

If it's the project that's "from scratch" then you have an excellent opportunity to do things right from the beginning - proper metadata management and control, adherence to in-house naming conventions and, above all, documentation. Grasp the opportunity - you won't often get it.

And remember, the statement "we'll do the documentation later" is never true.

vmcburney · Post by **vmcburney** » Tue May 20, 2008 11:14 pm

Have a look at the new DataStage Redbook as it takes you through a DataStage project scenario: DataStage Documentation and Examples in New 660 Page IBM RedBook. Not big on deployment tasks but covers standards and guidelines.