DSXchange

Hi All I'm getting this error when compiling the Job Sequencer <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the resource specified. '</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref> <Version>7.1.0.8</Version> </JobSeqGen...

kduke wrote:I told you.

Thank you Ray & Kim

I told my client to get MetaStage ( Reason they gave me that is doesn't support Oracle 10X )
I will tell then that we have to leave with this

Thank you & Have Great Day

I'm trying to access the DataStage Repository to create a Job for Metadata Reporting Purpose and also Auditing ( SOX implementation) I'm trying to access DS_Jobs, DS_Audit ... Etc hash files for DS repository. I want to understand the structure of this files i.e. how many columns are in each Hash fi...

srekant Create a Job Sequencer Job to load you tables in Sequential mode In the sequencer Call all you Primary Key tables loading Jobs first and followed by Foreign key tables, when triggering the Foreign tables load Job trigger them only when Primary Key load Jobs run Succesfully ( i.e OK trigger) ...

Abhi Check point work this as you told if 15th Job failed and if you have changed the 15th Job and recompiled it then you are changing the state of the ( Status of the Job from Abort to Compiled) when you restart seq it the previous run say the check point is active and step 15 failed and it will tr...

Ray Youy are correct it is very good tool when we need to standardizing and cleaning the data Mukund was telling that he can do the same in 1/2 day ( If you have Good Knowledge of QS you can do the Same in 1/2 day ) As his file are having same Meta Data if he developes the QS jobs for one file it wi...

what - Arnd suggested will work I have done the same in my project getting data from MainFrame

Thank you

harithay Is what is column name into which you are inserting the Surrogate Key I don't see that column name in the Update Sql or I'm I missing somthing Please update If I'm not worng what you are trying to do is in Update you are not taking the Surrogate Key Column as it is the Unique Key you are gn...

harithay Your design should look like this Target Table --->Hash File --------Ref Link For TransformStage1 Input File -----> Stream Link for TransformStage1 Out Put Link1 from TransformStage1 Target Table (Update) Out Put Link1 from TransformStage1 Target Table (Insert) This can be changed the is ba...

Fine do it in DataStage ( Save some money for your client ) if DS is going to Do what you want then take out QS don't bring it in and there is will be other headaches as you need to Calll this QS Jobs ( QS Scripts from in DS Sequncer so the it runs before running the your DS Job) Mukund if you can d...

Mukund; Quality stage is whole diffrent from Enterprise Edition and Job you need to develope in in Quality stage Env In Quality Stage you have four steps to do Investigate Standardize Match Survive If you are saying biffrent business rule for diffrent seq file than I think you need diffrent Jobs for...

Create a sh script and call it as after Job routine please check box after Job Run Sucessfully Bu doing this it will only run if the run sucessfully I create a flat file in one of my job sequences. I'd like to archive it with a date and timestamp at the end of my job sequence. Any elegant/simple way...

You got me on this and I agree I did a small mistake in my logic Thanks for Enlighting me Have good one Ram, You can just have one output link, without any input link. Trick: 1. Column value should be hardcoded, or derived the way its done my example in this post. 2. Have at least one stage variable...

Hi Guys, I'm bit confused seeing all your solutions for this. When using a transformer stage we need and input link and output link. The no of rows sent through output link depends on the no of rows coming from input. If you don't have the Input from transformer then you will not be able to send any...

Pay me 5Lakhs for Month I will do I batch :D

nchincholikar wrote:Hi everybody,

Can anybody help knowing PX trainer in India.


Regards,
Narendra