DSXchange

prasson_ibm

Hi,
can you please explain more to help others.Which version of datastage you are using.Once your job finished,where can you see it still running.What happens when you retrigger the same job again.

prasson_ibm

Hi,
Even in the case you are getting the warning and names are not duplicate in both the input links,they are usually being propagated invisibly through the job because RunTime Column Propagation is turned on.

prasson_ibm

Hi,
Change the column name in one of the link and try again.

prasson_ibm

Hi, We are also using MQ in our project beause it is already used by middleware technologies and we had to plugin DS accoding to customer rqeuirment. We are recieveing XML events in MQ,which decides which job need to be triggered in datastage. We parse this xml and trigger our job.later we send noti...

prasson_ibm

Hi,
After sorting,you can use transformer.write below logic in stage variable:-

Code: Select all

Svar=If keychange=1 then Inputcol.Year else Svar

Pass this variable to output derivation of Year then aggregate the data as suggested by chullet.

prasson_ibm

Hi,
After sorting,you can use transformer.below is the logic:-

Code: Select all

Svar=If keychange=1 then Inputcol.Year else Svar

Pass this variable to output derivation of Year then aggregate the data as suggested by chullet.

prasson_ibm

Dataset data file will be created at resource disk path used in configuration file.

prasson_ibm

Congrats ray!!!

prasson_ibm

Hi,

Create stage variables in transformer in below order:-

Code: Select all

CURR=Input.Col
COUNTER=if CURR=PREV THEN COUNTER+1 ELSE 1
SEQUENCE=if CURR=PREV THEN SEQUENCE+1 ELSE SEQUENCE
PREV=CURR

Initialze SEQUENCE to 1.
Map it to output derivation.It should be your result that you are looking for.

prasson_ibm

Hi Chullet,
Sure,you are saying is logical,thanks for your suggestion.

prasson_ibm

Hi Ray,
I saw they are running datastage on unix platform,thats why i suggested.

prasson_ibm

Hi, Before processing a file,design file validation job.Use two external source stages,your job design will be like this:- External source1---->Col Gen dummy-->Join On dummy----Transf---Copy External Source2---->Col Gen Dummy---> In External Source1 Stage Write below unix command:- head -1 File Name...

prasson_ibm

Hi,
I dont think parallel job is correct and efficient approach to split the files like this.You can better do in unix level,write a script to split the files the do the processing.

prasson_ibm

Hi, In Job termination activity stage,there are below options:- If any subordinate jobs are still running: A) Send STOP request to all running jobs And wait for all jobs to finish B) Abort Without sending STOP requests Wait for all jobs to finish first In my understand if i select both the checks in...

prasson_ibm

What partitioning logic you have applied on the input links of join stage?

DSXchange

Search found 531 matches

options in Job termination Activity sequence