DSXchange

Data in the job will be lesser,so better i ll go for option 1.

As suggested i am making transformer to run sequentially and sort stage will remain run in parallel mode.

But do you think that due to partition in the sort we could get wrong sorted sequence in transformer(running in sequence)..??

Hi,

I am planning to use aggregator stage.

I want to take saperate stream,create one dummy column 1 and aggregate data to take max timestamp value.
In this case i ll hash partition on dummy column,so do i need to run aggregator in sequence mode..??

Hi,
Thanks for reply.

I am trying to implement solution2,will keep you updated.


Thanks

Hi All, I have job design where i need to sort the data based on timestamp column(microsecond) and after sort apply transormation logic in transformer which should pick the max timestamp and populate for rest of records. Stage veriable value is:- If srt_to_tfm.LastChgDateTime>= svEFFDT then srt_to_t...

Hi,

How can i pass before subroutine's output to job parameter.
Actually i am writing a routine which will run the script and give as an ouptut with scema name.

How can i pass this schema name to job as job paramter.

Thanks
Prasoon

Hi,

In transformer you can do the derivation in this way:-

DatefromJulianDay(Juliandayfrom date(Input.date)-1))

I think it should work.

Thnaks

Prasoon

Hi All, This can be easily done in Datastage 8.5. Step 1:- Read the source as it is in single column. Step2:- Define two stage veriables . Svar1=Field(incol," ",1) Svar2=Field(incol," ",2) Define Loop Condition as:- AITERATION=1 Or RemainingRecord="" Loop Derivation:- I...

Hi, I am testing a vertical pivot stage in DS8.5. I have input like this:- "abc","def","jim" "abc","def","bob" "abc","def","tom" And i want output like:- "abc","def","jim","bo...

Thanks ray,But temporarily i need to help to trigger my routine....

I want all log information,so i have a loop which starting from lastest event id and decrementing by 1 and printing the value.
But i am getting only first log message not all message.

Do i need to place Ans out of the loop?

Hi All, I need help in creating a routine which will display director log in output. I have created routine as:- $INCLUDE DSINCLUDE JOBCONTROL.H JobName = Arg1 hJob1 = DSAttachJob(JobName, DSJ.ERRNONE) jobStart = DSGetJobInfo (hJob1, DSJ.JOBSTARTTIMESTAMP) latestID = DSGetNewestLogId(hJob1,DSJ.LOGAN...

I have a job having source as Oracle and Target as Teradata Enterprise stage.We are extracting data from oracle and loading data into TD using TD EE stage as Target. In Oracle one column INDV_ID has datatype as Number(9) and same column in Teradata has datatype as Decimal(9,0). We are reading this c...

Hi Ray,

Thanks for your suggestion,but i have multiple jobs creating these datasets,so i cant prepare a job to compare using difference stage,compare stage or change capture and meteadata for all these jobs are not same.Is there any way i can check the file differce (.ds) on unix/Aix server.

Thanks

Hi All,
I have dataset generating using Oracle and Teradata.
One job has source as Oracle and other has source as Teradata.
I need to compare two datasets generating from these two jobs.Is there any way i can compare datasets.

Thanks

Hi All,

Can anyone help me to resovle above mentioned issue.....