DSXchange

Sainath.Srinivasan wrote:If source and lookup are both Ora, why not do in db itself !!?

Search for Sparse and Performance.

Thanks ..in that case why use ETL itself if everything could be done efficiently in DB.!!

Any body please help me

Hi, My Requirement is to laod the data from oracle to sql server using parallel extender. while loading into sql server table, NextRunDate field having a datatype of datetime is populating with NextRunDate filed from oracle table datatype of timestamp. But records are not loading into sql server tab...

Hi, We have a job with src as Oracle table with 6 lookup stages(In memory) , followed by the Transforer for the business rules and then loads an Oracle table. It gets roughly 2k records Ths job takes startup time as 2.06 mins and 0.21 mins as production run time.So almost 90% of the time is used for...

Hi,

Before writing to the database,I am writing to a dataset and peekstage with target column decimal(28,12) and the value displayed as 0008710750824594.000000000000.

My table target column is number(28,12).I don't know why this value is
not accepting in table.Thanks.

Thanks chulett for the reply.
I am sorry for being so quick.

I have gone through those 9 posts already.but none helped me.Any knows
why this value 0008710750824594.000000000000 is not accepting
in an oracle table column of datatype number(28,12)?

Hi

If anyone faced this type of issue,Could you please help me?
Thanks in Advance.

Hi Dsxians, I am facing with a warning in datastage job and issue of insering decimal values into oracle DB. I have a multiplication of two string values from source file after converting from string to decimal 28,12 and doing a multiplication and storing in a target column of decimal 28,12. SVFirst...

Hi All, I am facing issue with ODBC Connecter PX stage while trying to use the Parameter from "Parameter Set". I would like to use the parameters in the "parameter set" to connect to the database (SQL server). But I am facing connectivity issues while i do that. When I use the pa...

Hi Cherry-

Did you got your problem solved?

If so,plz explain in detail how you did that-coz I am also facing the same issue currently.

cheers

Hi Cherry-

Did you got your problem solved?

If so,plz explain in detail how you did that-coz I am also facing the same issue currently.

cheers

Hi, I get the warning :LKP_ConsolAcct: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. I am uisng HASH Partitioning for both input links to the Lookup Stage. I have a Dataset and a Sort Stage...

Hi,

Could you please let me know the patch number for this issue of
status = 99 (Not running)?

If auto purging is disabled,then the problem is solved.

Thanks.

Thanks for your reply chulett. I couldn't read your entire message as i am not a premium member now. I came accross a post in dsxchange which has a suggession below regarding the same issue. Is Log Auto-purging enabled for either the Project or Jobs ? If so, please disable and retest. If this solves...

Hi chulett, The individual job is a multiinstance job and each time a different invocation id is passed from sequence. There is nothing descriptive in the log other than EDMOraDSErrorLog.REJ_ERR_PACE_POS_COLUMN_NOT_DERIVED_MFACTBOS_ERRMSG has finished, status = 99 (Not running) Strange thing is that...