DSXchange

Hey, Thanks in advance for the response My input is of format 971226 and I add 19000000 and convert to date using stringtodate function. But I get some invalid dates of format 112226 which results in 1911-22-26 where 22 is invalid month. Thus I see conversion error in director log and fatal error wh...

hey Ray, Thnaks for the response. Sometime, when I use fork-join, the job just runs for long time. I mean it never finishes. But I think I can implement it in 2 step process by temporary storage in Dataset. But still I would require aggrerator and a Filter/Transformer to implement this. When the vol...

Hi,

Can Anyone let me know the most eficient way to remove duplicates and store them.....

I can acheive this by using a transfromer and use a stage variabe or use sort and key change column.

Transformer becomes sequential and Sorting takes long time....

Is there any other way?

The reason I set tht to true was, when we use SQL LOAD option via datastage, it treats " " as Null and it dosent get loaded into the non nullable column. But when I set this ENV varibale, it works fine.

Also When I use Insert, it dosent get loaded with trailing spaces

Its Varchar2(5)

Hey, I am using LOAD option in oracle enterprise stage. When i load data into the VARCHAR Field, the data is getting loaded with spaces. Example Assume the job as follows Oracle -----> Transformer------->Oracle In transformer i am defaulting a value 'SM' for a column of datatype Varchar (5). when i ...

first thing is disable operator Combinability to see the full log. is the column in Oracle is represented as just number or of type number(2,4) ?

That was a typo.

Hey, I am using LOAD option in oracle enterprise stage. When i load onto the VARCHAR Field, the data is getting loaded with spaces. Example Assume the job as follows Oracle -----> Transformer------->Oracle In transformer i am defaulting a value 'SM' for column "Code" of datatype Varchar (5...

I tried to get in touch with DBA, still waiting for response. Right now running it in sequential.

Jus to update you fmcmullan, My index mode is rebuild and i am using partition table.

Hii , Can you guys guide me thru this error Oracle_Enterprise_154,0: Oracle call failed; sqlcode = -12801; message: ORA-12801: error signaled in parallel query server P028 ORA-00604: error occurred at recursive SQL level 2 ORA-00018: maximum number of sessions exceeded When I run the same job in seq...

Thanks for the response Ray. After enrichment, Used a temp table to perform such functions.

hey,

Is there a datastage euivalent function for oracle months_between function?

Thanks

hey, thaks ray. I used functions to resolve this. actualy stripped first two character and passed back 20 or 19 depending on the cc code and concatinated with rest of the 5 digit code. So its changed from CCYYDDD to YYYYDDD which i sent via stringtodate to resolve

Hi guys, The source data is coming in from mainframe and when i import the CFD, the columns are in decimal and of format "0207354", "0197356". When I decoded this, the first 2 character represents the century which is if 02 , then 2007 or if 01 then 1900 . the next 2 characters r...