DSXchange

As number of installements will be veried on each account therefore join stage will merge the records based on account number and later on calculation will be applied in transformer stage as per my example. Actually, i like your solution more with sort stage and tested the data it works for this req...

Hello Friends, Need your input to create better datastage design. Well let me tell you my input data and what i want to achieve from input data. Input Data Installment AcctNumber Earned Interest Total Interest 0 abc 17.09066667 1237.2 1 abc 37.88133333 1237.2 2 abc 39.86433333 1237.2 3 abc 36.711666...

Yes, Removed the old table difination completely and import the new defination in repository and in to job also. [quote="ray.wurlod"]Did you also update the link from the table definition in your repository into your job - effectively re-load the table definition into your job? If not, you...

Hi,

Same warnings after importing metadata from Orchestrate orchdbutil for that particular table.

Thanks & Regards, HHH

[quote="ray.wurlod"]Import the table definition using Orchestrate orchdbutil. Use the imported table definition without modification. ...[/quote]

Hi All, Could you pleaese guide me on following issue of metadata : While extracting data from oracle(9i) table , getting following warning messages : 1) Orcl_Valid_Stat_Extract: Column SEQUENCE_JOB_ID floating point decimal is not fully supported; adjusting the scale. 2) Orcl_Valid_Stat_Extract: Wh...

Hi All, Have requirement of to get number of days between two dates, have used date format as yyyy-mm-dd in DaysSinceFromDate function . While running datastage job , getting few warnings like : "DW_AcctArrg_Tfm1,4: Conversion error calling conversion routine days_since_from_date data may have ...

Hi All,

There is a requirement to load large amount of data and for that i need some inputs on pivot stage and parallel transfer stage, which one is most faster !!

could any guide me comparison between pivot stage and px transformer stage.

Appreciate you help !!

I was such a stupid that i was using just dsjob in place of ./dsjob. Thanks, Thompson [quote="thompsonp"]The directory containing dsjob is not in your PATH. If changing to that directory does not help, then . (the current directory) is not in your PATH either. Run the command from the bin ...

Hello,
In ....DSEngine/bin directory dsjob command is available however i am trying to use dsjob command at that time i am getting
"dsjob: command not found"
have set the appropriate library path also , but still i can not use dsjob command.
pls suggest your ideas on same.
Regards,
Hiten

Is there any environment variable so we can eliminate such kind of warning message.


[quote="ArndW"]Please look at your [u][i]Parallel Job Advanced User Guide[/i][/u] and search for "message handler" to get details on how to implement this functionality. ...[/quote]

How can i handle through Message Handler ? pls suggest [quote="ray.wurlod"]It's reporting that your Wrapper stage finishes successfully. I guess it's a warning because the framework does not expect to find Wrapper stages, and so marks it as "unusual". Use a Message Handler ...[/q...

Hi,
I am calling script from wrapper stage.I am getting warning "WrapperStageName,Status code = 0"
This warning apperars when my script runs successfully only.
But in logfile how can i eleminate this warning message.

Please advice me on this issue.
regards,
Hiten

Hi Ray,
In one of our project , we dont use server job.
[quote="ray.wurlod"]Why not use a server job? ...[/quote]

We have universe database stage in server job so what is corresponding stage or any utility in PX ?
As i want to find out all job name in current project.
Please suggest me on this topic.

Regards,
Hiten

I am reading data from xml file(Sequential File Stage). My job design is like : SeqFileStage --> XmlInputStage --> XmlTransformerStage. In xml transformer stage i am giving output file name. while running this job first i got warning message " XML_Transformer_13,0: Error: The transformation XSL...