DSXchange

@Thanks for the input 1)Target is key partition 2)I am running the JOb for 63 iterations using Loop activity in Sequence.For each iteration the volume of input data is 50 Lakhs approximately Clarification: 1)Is select Enabled partition=YES and Hash partitioning will effect aggregator functionality? ...

Hi all, Job is running for a long time Orcale connector(source)-->aggregator--->transformer-->Orcale connector(Target) source oracle connector consists of query using 4 tables joined based upon Join Keys. Enabled partition=No, so the oracle connector is running in the sequentail Mode. In aggregator ...

1)what is double data type in datastage?can anybody explain some sample data for double datatype 2)Does double and decimal datatypes have any similarities?i am confused everytime when to use double and decimal Double data type-double-precision (64-bit) floating point value.Not able to get what exact...

The logic looks good. An alternative, which may be more efficient especially if the list of codes grows, would be lnk_xfmr_target.DIR ='IN' AND lnk_xfmr_target.CD_FLAG ='D' AND Index('|ARC|PPD|CCD|CTX|COR|DNE|','|':lnk_xfmr_target.CLASS:'|') < 1 could anybody explain what is the need for | and conc...

By Using MetaDataWork Bench we can find what is the source[Table] for a particular field in a Report?Just want to know In this case the reporting Tool should be IBM Cognos or will it work if it is some other reporting tools like Bo etc. Note:MetaDataWork Bench is not installed in my system Just want...

1)Select the container from repository and right click select find where used

2)if u want to find the list of the job names and folder where a particular stage or object is used follow this link

http://datastage-vamsi.blogspot.in/2012 ... s-and.html

By using istool we can export and import various Information Server components components/assets. With respect to Datastage Asset means Mainframe job ,Parallel job ,Sequence job,Server job etc. 1)what is meant by Asset exactly with respect to Information Server components? 2)Is there any way to find...

Hi For each Database we have different Stages but donot know when to use which stage? Oracle--Oracle connector,Oracle enterprise,oracle OCI Load Teradata-->Teradata connector,Teradata enterprise,Teradata Load,Teradata Multipload ofcourse,we have seperate manuals for each Stage.Before starting the ma...

1)Job1--->Job2-->..................... Job10 exceptional Handler--->execute Command Activity 2)In execute command stage call the unix script and folllowing things to be performed a)For each Job check the Job status and if it is aborted send the mail use dsjob -jobinfo,loop,grep,mail commands in the ...

I am using below source file which is sample data.I am able to read the data with quote=none or double or single[Field level property] col1,col2 1,a 2,b 3,c 4,d But input data does not have any double or single quote's for any one of the fields?Just what to know why Job is not throwing any error or ...

If you are using sequence use execute command activity to trigger the unix script.In unix script you can rename the file

1)After creating reject files create one file body.txt which contains output Input file records : 100 Reject file 1 records : 10 Reject file 2 records : 0 Reject file 3 records : 0 Reject file 4 records : 50 Reject file 5 records : 5 Use wc,loop and echo commands 2)Finally include below command in t...

@ray.wurlod
Thanks for your input.It is working fine now.

I think we do not have any Direct function in Datastage,otherwise you have to write external parallel routine suggested by jerome_rajan

If is oracle means then u can use below query

select to_char(to_date(1500 ,'j'),'jsp') from dual;

If it is some other Database means use equivalent functions for to_date,to_char