Help Required

[sudhansu]

Hi Friends .

I am new to Dastage . I need some help from you peoples .

I developed some server jobs and i want to test that jobs .
So please suggest me the process i have to follow to test server job .

My server job includes one oracle stage and a transformer and a sequential file stage .

Data wiil pull from oracle stage and cleansed in transformer stage and finally save in sequential stage .

Looking forward to your reply .

Thanks
Sudhansu

[Minhajuddin]

After designing the whole job.

you need to follow these steps...

--> Save the job.

--> Compile the job.
And remove compilation errors if any.

--> Run the job
And remove the runtime errors if any.

And finally viewing the data in your target file and verifying whether you have the desired output.

And if you can tell us what you want to do in the transformer, We can help you better.

Hope that helps...... :D

[ray.wurlod]

What is your jo design intended to do? Are there any business rules that have been implemented and which therefore need to be tested? Create a test plan, including test data with which to test the efficacy or otherwise of your implementation of those business rules.

[sudhansu]

What is your jo design intended to do? Are there any business rules that have been implemented and which therefore need to be tested? Create a test plan, including test data with which to test the e ...

Hi Ray

Please tell me how to create test data in datastage .

[ray.wurlod]

Typically you don't. You create test data and use those data to test that DataStage is doing the right thing.

Of course you can. You can use the Transformer stage with no input link as a row generator. Derive all the columns using whatever expressions you like. Include a constraint expression of the form

Code: Select all

@OUTROWNUM <= #MaxRowsToGenerate#