DSXchange

Team, I am doing bulk load on oracle. It has time stamp column. In DB NLS_TIMESTAMP_FORMAT ser as 'dd-MMM-YY HH:MI:SS'. Datastage I tried to change default time stamp format as 'dd-MMM-yy HH:MI:SS'. when I write to Dataset and see it is still in 'dd-mm-yyyy hh:mm:ss' format . Because of it, Bulk loa...

Hi, Currently we are testing the option of always -on job by creating a datastore in CDC to connect to Datastage, but facing some problems due to version mismatch between the CDC tool and Datastage, will update this forum once we show some progress.

Thanks Craig, I will look in to the SOA Editions and will update on this forum. Regarding the volume it should be 3 to 7 Million records.

Hi,

Could anyone please help me on this

Thanks

Hi, I am currently looking for acheiving real time ETL scenario using CDC transaction stage , i have read about this stage , but need few clarifications , using this stage does the datastage job will be online everytime ? also does this stage trigger the datastage job whenever there is a update in s...

Thanks for all the replies.Below code is working as per my requirement

Can anyone help me in converting normal date into Julian Date. For eg: if we input 20160219 my output will be 116050(CYYDDD) format. I have code for the reverse conversion (From Julian to Normal Date) OCONV(ICONV(Arg1 + 1900000, "D4-"), "D4-YMD[4,2,2]") But not able to find a sol...

Hi All Can any one help with the command for subtracting hours from a date time field in uservariable activity stage. For eg if I have a input value as 2015-09-21 10:00:00, need to subtract 2 hrs from it and need o/p like 2015-09-21 08:00:00 I think Iconv/oconv function will work.If any one knows pl...

Hi All When I am trying to trigger a job its getting aborted by showing the below error. [main_program: Internal Error: (contextValue && *contextValue >= eSource && *contextValue <= eRequest): pxbridge.C: 7386 Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are in...

Below is the command used in datastage and the output it is giving as cd /Gft_Prod/LEGREL2PDIN/ProjectData/input/PremiumPaid;ls -1atr *PREMIUMPAID* |head -1; Reply=0 Output from command===> PREMIUMPAID20120523002831.t********t Actual input file in the server is PREMIUMPAID20120523002831.txt when I m...

I'm using datastage 8.5 version. Issue: I have only one file premium05242012.txt file in one folder in my production server. When I executed ls command in that specific folder in job sequence in datastage it is returning the filename as premium05242012.t******t. because of this my jobs are getting a...

thanks

i get the following error while i click on view data ##E IIS-DSEE-TFOP-00020 22:42:25(001) <Oracle_Enterprise_0> Error occurred during initializeFromArgs(). ##E IIS-DSEE-TDOR-00008 22:42:25(002) <Oracle_Enterprise_0> Missing server name; cannot connect. ##E IIS-DSEE-TDOR-00140 22:42:25(003) <Oracle_...

Hi, I am new to parallel edition. I created a job to load data from one oracle table to another table. I was able to import the metadata data config for both the source as well as the target table. but i was not able to view the data at the source nor i was able to compile. Do i need to add any para...

I am quite new to Datastage 8. Can you explain in detail how to disable the operator combination?

Thanks,
Star