DSXchange

decimal[1,0] is a tiny number (at most one digit). I think you need to correct a typing error in your metadata. You are getting much larger numbers (with up to 14 digits) to load into this fi ... Yes i do define the columns data type as Decima(18,2), but i am not able give the same in specification...

I tried the with the option of defining output column in the aggregator as Double and convert the same in the modify stage. This gives the runtime error as follows. derivation in modify stage is as follows DB_AMT:DECIMAL= decimal_from_dfloat(DB_AMT) modify(0),3: Un-handled conversion error on field ...

Kumar i will try the option you have mentioned and let you guys know the result.

Thom,

Can you give bit more info on the build-op.

Thanks & Regards
Thamark

I have job to calculate the no of records and sum of the amount field to ensure that the no of record extracted and inserted and same, but i am facing one issue on the same as follows. 1) Amount is differs between the extraction and insertion, if no data type is defined for the output columns at the...

The previous timestamp is passed out via UserStatus and comes into the Extract job as a parameter to constrain the where clause to only transactions that have occurred after the previous extract.

Can you please give some more detail on UserStatus. How this is passed and all?

Hi Everybody, Please help me out on the bellow questions. 1) Is it posible to load data from Flat file to Tandem Database using DataStage? 2) If yes to the above how can we do this? Please give me some detail of that. 3) If we can load using DataStage approximately Please give some performance stati...

[img][ quote="dennism"]I can connect to the database thru sqlplus and toad. this is another error log after the one i've already posted: JOLoadDfLoadProfile2a..ORA_Lp_raw_max_tabs.LK_ORA_Lp_raw_max_tabs: DSD.BCIClose SQLSTATE=60, DBMS.CODE=-3113 [DataStage][SQL Client][ODBC][DataDirect][OD...

Hi Everybody, Please clarify me on the follwing 3 points. 1) Using DataStage can we able to load from DB2UDB to TANDEM? If yes how can we achive it? 2) If at all we are get thru in the first step how long DataStage will take to load 2 millon records with some trasformation? 3) Is there any encryptio...

I have Database to XML generation job. I need to do the reconcillation of the same, how could i able to achive this. counting number of records in the XML file at XML side in DataStage. example. <Main Tag> <Total Tag> <SubTag1Total>7</SubTag1Total> <SubTag2otal>7</SubTag1Total> <SubTag3otal>7</SubTa...

There are 5 rows with 6 column in it. I want to write the first row as single column of data with 5 rows in it. because remaining will be the same.

Thanks for your response in this regard.

Regards,
Kannan