Hi,
I am new to datastage, it would be great if some one can provide me a sample job in which a fact is getting loaded from DIMs and Staging Tables. This will help me in understanding that what all steps are required to create a job efficiently.
Though I have made a few but I think they are not made with best practice. That is why I want to see a sample job. I request you all to help.
Regards
Need a sample job
Moderators: chulett, rschirm, roy
Need a sample job
!! Ashutosh G !!
Re: Need a sample job
Nice wish !!mint_ag wrote:Hi,
I am new to datastage, it would be great if some one can provide me a sample job in which a fact is getting loaded from DIMs and Staging Tables. This will help me in understanding that what all steps are required to create a job efficiently.
Though I have made a few but I think they are not made with best practice. That is why I want to see a sample job. I request you all to help.
Regards
Haha ... realistically you can start by working hard.
Search this forum for best practices/job tuning
Read the advanced guide
Create the same job with alternative flow and strategy and capture metrics
Don't lose heart, cheers !!
:D
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
You might find some of the jobs available <a href="http://www.tools4datastage.com/partnertools/">here</a> informative. E.g. ETLStats.
J.
J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>